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 “planks” 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.

117 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
planks12411675(None) 
blanks124112891blanks
clanks124615181clanks
flanks133913401flanks
placks144414151placks
planes85028081planes
plank115221141plank_
plans75731271plan_s
plants84921801plants
plinks124913261plinks
plonks124210421plonks
plunks124711161plunks
pranks124814721pranks
alands75418372alands
alans55636172alan_s
alants67722022alants
banks115527902_banks
blacks144914952blacks
blank115418552blank_
blinks124613572blinks
branks124817382branks
clacks144516342clacks
clangs95113612clangs
clank114719522clank_
clanky15469072clanky
clans75031012clan_s
clinks125815062clinks
clonks125013472clonks
clunks124811012clunks
cranks125015312cranks
elands74914772elands
elans55527752elan_s
flacks154114532flacks
flanes94522422flanes
flank124618092flank_
flans85327972flan_s
flasks13488672flasks
flunks13469862flunks
franks134912732franks
glands85314402glands
glans65125832glan_s
hanks126226862_hanks
lacks116129202_lacks
lands65426902_lands
lanes54946792_lanes
lank84734442_lank_
lanky125517482_lanky
larks95227812_larks
links96430192_links
llanos6108332llanos
lunks94822452_lunks
packs135528932p_acks
paiks114719852p_aiks
panes76148692p_anes
pangs84628662p_angs
pans65855722p_an_s
pants76536922p_ants
parks116134462p_arks
peaks114825622pea_ks
peans75437642pean_s
pianos84315932pianos
pians75126962pian_s
pinks115729382p_inks
places104323702places
plack135017842plack_
plages94520152plages
plaids94312442plaids
plains85019592plains
plaints94012052plaints
plaits83816472plaits
plan65833942plan__
planar84212712planar
planch133711442planch
plane74929142plan_e
planed94420912planed
planer84122652planer
planers94517942planers
planet84228352planet
planets93914082planets
planish12412052planish
planked143512282planked
plant75437112plan_t
plasms103711332plasms
plates85432242plates
plats75531372pla_ts
platys11459852platys
playas114612282playas
plays106320772pla_ys
plazas17409912plazas
plink115219122plink_
plonk114613982plonk_
plucks14379732plucks
plunk114514402plunk_
plunky15377952plunky
prangs94816232prangs
prank115019452prank_
prinks124315382prinks
punks114822682p_unks
ranks95225732_ranks
shanks135315582shanks
skanks94710832skanks
slacks124416532slacks
slangs75615342slangs
slank95822772slank_
slants64819082slants
slinks104315152slinks
spanks124514122spanks
stanks104917702stanks
swanks134811562swanks
tanks94624732_tanks
thanks134313132thanks
tranks104017762tranks
ulans54921302ulan_s
uplands1036942uplands
uplinks13345612uplinks
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.1401276364.3
2DLD Change Limit825511172.72030349.6
3Display Results1171170.0462543.5
 (SQL Overall)1786911172.90661490.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.