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 “whist” 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
whist11532295(None) 
hist76551541_hist
shist84829611shist
waist86132381waist
whilst1239141whilst
whipt135317421whipt
whish144512921whish
whisht154510811whisht
whisk154510141whisk
whists124613811whists
whit104834171whi_t
whits115923821whits
wist78049291w_ist
wrist84827561wrist
agist66325582agist
ahis76135382ahis_
alist56136782alist
chest104926142chest
chis95933312chis_
chit96937462chi_t
chits105424572chits
cist67244962_cist
deist64633592deist
exist124618942exist
feist86230072feist
fist76248422_fist
foist85730972foist
ghast95621222ghast
ghis85020162ghis_
ghost96318762ghost
gist56046762_gist
grist65529872grist
hast76259482_hast
heist87030912heist
hest75950772_hest
hilt75850712_hilt
hint77455742_hint
his66359502_his_
hisn79620932_hisn
hiss75629212_hiss
hists86328372_hists
hit66569192_hi_t
hits75545132_hits
hoist86433212hoist
host77852832_host
joist125125652joist
khis117017982khis_
kist86540802_kist
list47055342_list
maist75535682maist
mist66154532_mist
moist76033582moist
neist54628442neist
odist6421912odist
phis95724902phis_
schist11312652schist
shiest95821532shiest
shift114225142shift
shirt84533902shirt
shists96515112shists
shit76745942shi_t
shits84731172shits
theist9314762theist
thirst9312252thirst
this76027382this_
twist86820982twist
waists97415452waists
wait75553692wai_t
waits88333522waits
wast75655852w_ast
weest85026772weest
west75748082w_est
what105434072wh_at
whats117718992whats
wheat114924572wheat
whet105133782wh_et
whets115019612whets
which163910082which
whid115418872whi_d
whids125413982whids
whiff17310062whiff
whig115516422whi_g
whigs125612642whigs
while115418692while
whim126220532whi_m
whims134515332whims
whimsy17375222whimsy
whin105225692whi_n
whine116022812whine
whins114922332whins
whiny144915572whiny
whip125521842whi_p
whips134917082whips
whir105519282whi_r
whirl114913822whirl
whirr114611192whirr
whirs115218092whirs
whishts16425312whishts
whisks16497352whisks
whisky19455902whisky
whisted144010012whisted
whistle13107532whistle
white114920302white
whitest133710112whitest
whity145513472whity
whiz195919942whi_z
whizz194210322whizz
whort114623692whort
whose114914532whose
whoso11509222whoso
whys137011662whys_
wilt76246292w_ilt
wis66552332w_is_
wise75737342w_ise
wish107228732w_ish
wisp97124072w_isp
wiss75630542w_iss
wists86728522w_ists
wit66563772w_i_t
wits76044872w_its
worst86330132worst
wost76544362w_ost
wrest84925432wrest
wriest94419712wriest
wrists95415642wrists
wristy12509702wristy
writ75537912wri_t
writs86624382writs
wurst85122992wurst

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001291.34340059.6
3Display Results1291290.0462804.3
 (SQL Overall)1786911291.702104988.8
 
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.