Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “flanks” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
flanks13391340(None) 
blanks124112891blanks
clanks124615181clanks
flacks154114531flacks
flanes94522421flanes
flank124618091flank_
flans85327971flan_s
flasks13488671flasks
flunks13469861flunks
franks134912731franks
planks124116751planks
alands75418372alands
alans55636172alan_s
alants67722022alants
banks115527902_banks
blacks144914952blacks
blank115418552blank_
blinks124613572blinks
branks124817382branks
clacks144516342clacks
clangs95113612clangs
clank114719522clank_
clanky15469072clanky
clans75031012clan_s
clinks125815062clinks
clonks125013472clonks
clunks124811012clunks
cranks125015312cranks
elands74914772elands
elans55527752elan_s
fanes84639892f_anes
fangs96224072f_angs
fanos85926502f_anos
fans76247372f_an_s
finks125424222f_inks
flabs105818642fla_bs
flack144519412flack_
flags95321282fla_gs
flails94313002flails
flairs95711912flairs
flak116026172fla_k_
flake125119972fla_ke
flakes134118872flakes
flaky155715582fla_ky
flames114723692flames
flams105125012fla_ms
flan76134182flan__
flange103411972flange
flanges113413272flanges
flanked153710642flanked
flanken14226762flanken
flanker143911292flanker
flankers15349302flankers
flaps105621382fla_ps
flares94521702flares
flask125512422flask_
flats86429742fla_ts
flatus94310782flatus
flaunts1056132flaunts
flaws115920342fla_ws
flaxes165015352flaxes
flays116321052fla_ys
flecks154310802flecks
flicks154512992flicks
flings106715282flings
flints95617452flints
flocks154713532flocks
flongs105010492flongs
flunk125014382flunk_
flunky16408092flunky
francs114112192francs
frank124417512frank_
funks125318912f_unks
glands85314402glands
glans65125832glan_s
hanks126226862_hanks
lacks116129202_lacks
lands65426902_lands
lanes54946792_lanes
lank84734452_lank_
lanky125517482_lanky
larks95227812_larks
links96430192_links
llanos6108332llanos
lunks94822452_lunks
placks144414152placks
planes85028082planes
plank115221142plank_
plans75731272plan_s
plants84921802plants
plinks124913262plinks
plonks124210422plonks
plunks124711162plunks
pranks124814722pranks
ranks95225732_ranks
shanks135315582shanks
skanks94710832skanks
slacks124416532slacks
slangs75615342slangs
slank95822772slank_
slants64819082slants
slinks104315152slinks
spanks124514122spanks
stanks104917702stanks
swanks134811562swanks
tanks94624732_tanks
thanks134313132thanks
tranks104017762tranks
ulans54921302ulan_s
wanks126124482_wanks
yanks125316572_yanks

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.330541487.9
2DLD Change Limit825511112.34335233.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911112.71965719.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.