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 “stunts” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
stunts6561525(None) 
shunts95712021shunts
stents65019451stents
stints65119761stints
strunts7429541strunts
stuns54719491stun_s
stunt55328171stunt_
sturts63915141sturts
aunts55227632_aunts
blunts84512892blunts
brunts85215452brunts
bunts75729802_bunts
counts84618272counts
cunts76125122_cunts
daunts75014082daunts
dunts65828412_dunts
founts94313382founts
grunts75511852grunts
haunts95614392haunts
hunts86826172_hunts
jaunts137511882jaunts
lunts55826902_lunts
mounts84115072mounts
punts75828002_punts
runts55927632_runts
saints65122422saints
saults65816172saults
saunas63915432saunas
scants85219722scants
scents85317022scents
scuts74522522scu_ts
shuns85018142shun_s
shunt85226512shunt_
shuts85622482shu_ts
skunks9468162skunks
slants64819082slants
sluts54523982slu_ts
smuts75415712smu_ts
sounds74616182sounds
spunks12349332spunks
spurts84814972spurts
squats153712962squats
squints16339032squints
stands75118052stands
stanes64933402stanes
stangs75018172stangs
stanks104917702stanks
starts65423122starts
stats55933362st_ats
stenos63915772stenos
stent55634512stent_
stets55423912st_ets
stilts67915312stilts
stings76220182stings
stinks105616832stinks
stint57037662stint_
stoats65117482stoats
stones65130032stones
stots54828552st_ots
stotts64612862stotts
stounds8377822stounds
stouts65019002stouts
strunt64918912strunt_
struts65616802struts
stubs75016072stu_bs
students954682students
studs64415872stu_ds
stuffs123810222stuffs
stulls63912982stulls
stumps104912282stumps
stums75320082stu_ms
stun45623452stun__
stung65417152stun_g
stunk94616292stun_k
stunted83010402stunted
stupas83910882stupas
stupes84116952stupes
sturt56028962sturt_
suets55126102s_uets
suints64617782suints
suits55028052s_uits
sunns55017352s_unns
suns45841902s_un_s
taunts65715662taunts
tents56434212_tents
tints56030922_tints
tufts85713272_tufts
tunas54224122_tunas
tunes55332192_tunes
tungs65520632_tungs
tuns45138662_tun_s
tuts45838452_tu_ts
vaunts95212622vaunts

Search took 4 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 Limit82551932.65631080.9
3Display Results93930.0303100.0
 (SQL Overall)178691933.02958993.4
 
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.