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

145 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
while11541869(None) 
awhile1257791awhile
chile105626891chile
whale115517431whale
whiled134514131whiled
whiles124418011whiles
whine116022811whine
white114920301white
whole114418091whole
wile75944371w_ile
agile65122262agile
anile54634462anile
axile126020512axile
bile66147182_bile
chicle134312542chicle
chide115321012chide
chiel104918972chiel
child114516222child
childe124711212childe
chiles115425302chiles
chili106218482chili
chill105619872chill
chime125322592chime
chine105231722chine
chive135117622chive
chyle134913482chyle
dhole95215362dhole
edile64819492edile
exile126117652exile
file75446642_file
guile64521132guile
hale76052832_hale
hide85134642_hide
hie67652702_hi_e
hike116830392_hike
hila76228352_hila
hili75626632_hili
hill76439492_hill
hilt75850712_hilt
hire75538962_hire
hive106029672_hive
hole77553392_hole
maile75232222maile
mile66352572_mile
phyle134111152phyle
pile65649692_pile
rile45650532_rile
shale85332832shale
shiel811023772shiel
shill85325332shill
shily115222012shily
shine85533092shine
shire84727132shire
shive114423422shive
smile74823922smile
spile75230082spile
stile54931572stile
thill85918732thill
thine85026862thine
thole85620842thole
tile45451442_tile
toile54626492toile
utile54718932utile
vile76139802_vile
voile84719722voile
wahine123813012wahine
wail75238822wail_
wailed104823592wailed
wailer93720322wailer
wails86631482wails
waive114214602waive
wale74546432w_ale
whaled134612032whaled
whaler124611972whaler
whales124716942whales
whee105429592wh_ee
wheel115515332wheel
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
where117019422where
which163910082which
whid115418872whi_d
whids125413982whids
whiff17310062whiff
whiffle1933532whiffle
whig115516422whi_g
whigs125612642whigs
whilom1436132whilom
whilst1239142whilst
whim126220532whi_m
whims134515332whims
whin105225692whi_n
whined134715202whined
whiner124516632whiner
whines125120102whines
whiney155012642whiney
whinge134311542whinge
whins114922332whins
whiny144915572whiny
whip125521842whi_p
whips134917082whips
whipt135317422whipt
whir105519282whi_r
whirl114913822whirl
whirled14368042whirled
whirler13307602whirler
whirls124710532whirls
whirly15448862whirly
whirr114611192whirr
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whistle13107532whistle
whit104834172whi_t
whited134814082whited
whiten124111922whiten
whiter124316392whiter
whites123919882whites
whitey154911882whitey
whits115923822whits
whittle13106102whittle
whity145513472whity
whiz195919942whi_z
whizz194210322whizz
wholes124616772wholes
whore116018042whore
whose114914532whose
wide85235412w_ide
wife105228022w_ife
wild85126512w_ild
wiled95231552w_iled
wiles85437872w_iles
will75737512w_ill
wilt76246292w_ilt
wily106428812w_ily
wine74953422w_ine
wipe94830282w_ipe
wire75839812w_ire
wise75737342w_ise
wite75443272w_ite
wive105931752w_ive
write85522832write
wyle105519382w_yle

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 Limit538001451.51335558.5
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.87295454.6
 
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.