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

129 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
stanks10491770(None) 
shanks135315581shanks
skanks94710831skanks
spanks124514121spanks
stacks124317261stacks
stalks104614551stalks
stands75118051stands
stanes64933401stanes
stangs75018171stangs
stank95823301stank_
stinks105616831stinks
swanks134811561swanks
tanks94624741_tanks
banks115527902_banks
blanks124112892blanks
branks124817382branks
clanks124615182clanks
cranks125015312cranks
flanks133913402flanks
franks134912732franks
hanks126226862_hanks
planks124116752planks
pranks124814722pranks
ranks95225732_ranks
sacks114228872s_acks
sands65228582s_ands
sanes55649072s_anes
sank85236832s_ank_
sans45153362s_an_s
sarks96632462s_arks
satangs8479712satangs
scans74625102scan_s
scants85219722scants
shacks154817562shacks
shank125422192shank_
sharks135019722sharks
sinks95529182s_inks
skank84415582skank_
skanky12476962skanky
skinks94511652skinks
skunks9468162skunks
slacks124416532slacks
slangs75615342slangs
slank95822772slank_
slants64819082slants
slinks104315152slinks
smacks144112322smacks
snacks124514552snacks
snarks104815732snarks
soaks95220292soa_ks
spank115919572spank_
spans74528732span_s
sparks124616362sparks
spunks12349332spunks
stabs76221382sta_bs
stack114421692stack_
stades74626242stades
staffs12349752staffs
stages75629492stages
stags66226742sta_gs
staigs75414812staigs
stains64923652stains
stairs65416332stairs
stake95927532sta_ke
stakes103927292stakes
stales65538292stales
stalk94518002stalk_
stalky13499302stalky
stalls64019932stalls
stamps105614022stamps
stance84316912stance
stances93715962stances
stanch113812372stanch
stand65923282stan_d
stane55933002stan_e
staned74824642staned
stang66424692stan_g
stanol6310722stanol
stanols739732stanols
stanza1537072stanza
stanzas1636362stanzas
stapes85028732stapes
staphs114411032staphs
stares66038752stares
stark95425622stark_
stars55836572sta_rs
starts65423122starts
stases64225562stases
stasis63116872stasis
states64337082states
stats55933362sta_ts
status65515212status
staves94525192staves
stays86022022sta_ys
steaks104415852steaks
steeks103613702steeks
stenos63915772stenos
stents65019452stents
sticks125118612sticks
stings76220182stings
stink95122502stink_
stinko10499392stinko
stinky134611072stinky
stints65119762stints
stirks104914242stirks
stocks124715632stocks
stones65130032stones
stooks105115372stooks
storks106115952storks
strands83711952strands
stunk94616292stunk_
stuns54719492stun_s
stunts65615252stunts
swank125318232swank_
swanky16447972swanky
swans84625012swan_s
swinks134610652swinks
tacks115430132_tacks
talks94322692_talks
tangs65028362_tangs
tank85134032_tank_
tanka93817492_tanka
tankas104613772_tankas
tans46154832_tan_s
tasks94917582_tasks
thanks134313132thanks
tranks104017762tranks
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.343520965.0
2DLD Change Limit825511292.54632423.8
3Display Results1291290.0462804.3
 (SQL Overall)1786911292.93560882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.