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

120 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
whales12471694(None) 
hales85449841_hales
shales94731251shales
wales86142831w_ales
whale115517431whale_
whaled134612031whaled
whaler124611971whaler
whalers13529701whalers
whiles124418011whiles
wholes124616771wholes
ales47067102__ales
bales76250082_bales
chafes145017912chafes
chaleh143711992chaleh
chalehs15268802chalehs
chalet113825992chalet
chalets122813472chalets
chalks155412142chalks
chapes135421872chapes
chares115631802chares
chases115128232chases
chiles115425302chiles
chyles144813282chyles
dales66439742_dales
dhals95415442dhal_s
dholes104914792dholes
exhales1737142exhales
gales65442482_gales
hades96035112_hades
haes77651022_ha_es
hajes155420942_hajes
hakes126034302_hakes
hale76052832_hale_
haled95335822_haled
haler85033522_haler
halers94926912_halers
halest94823272_halest
halls85633782_halls
halms105225212_halms
haloes94623862_haloes
halos85230252_halos
halts85230102_halts
halves124717092_halves
hames106138702_hames
haoles94919802_haoles
hares86255542_hares
hates86742572_hates
haves116034872_haves
hazes174928322_hazes
holes84748652_holes
inhales10511862inhales
kales95730982_kales
males75049792_males
pales75753802_pales
phages125213512phages
phases114618402phases
rales54947492_rales
reales64934122reales
sales56055592_sales
scales84529312scales
shades105924532shades
shakes135024592shakes
shale85332832shale_
shaled105023952shaled
shaley123714992shaley
shames114726222shames
shapes115124942shapes
shares95236412shares
shaves125224932shaves
spales84728102spales
stales65538292stales
swales93920762swales
tales55451372_tales
thaler94613102thaler
thalers106212262thalers
thanes94918982thanes
tholes94919782tholes
vales85434262_vales
wades95634142w_ades
waes76048602w_a_es
wages95330932w_ages
wakes126633652w_akes
wale74546432w_ale_
waled94330992w_aled
waler84229262w_aler
walers94824462w_alers
walies95324522w_alies
walks126218502w_alks
walls85529382w_alls
wames106432802w_ames
wanes85040882w_anes
wares88250582w_ares
waves115633922w_aves
waxes155825502w_axes
wealds10459102wealds
weals85428742weal_s
weaves123616372weaves
whacks184610482whacks
whams135515642wha_ms
whangs13439722whangs
whaps135115162wha_ps
wharfs1546372wharfs
wharves16457132wharves
whats117718992wha_ts
whaups14405752whaups
wheals124512522wheal_s
wheels123811712wheels
whelks16367322whelks
whelms14377572whelms
whelps14437842whelps
wheres125917432wheres
while115418692while_
whiled134514132whiled
whines125120102whines
whites123919882whites
whole114418092whole_
whores125617102whores
wiles85437872w_iles
woalds10427582woalds
wyles114615322w_yles

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.1101624463.6
2DLD Change Limit825511202.84329036.6
3Display Results1201200.0304000.0
 (SQL Overall)1786911202.98359903.1
 
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.