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

140 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
whys13701166(None) 
ways107737951ways
wheys145911551wheys
why126920011why_
abys97221882abys
ahis76135382ahis
ahs68644822ah_s
ays67050292_ays
bays97143912bays
beys913829552beys
boys96737332boys
buys95726792buys
bys85229462_bys
cays95437672cays
chays135319742chays
chis95933312chis
coys97537242coys
days87637132days
deys85027472deys
drys86314802drys
fays108535362fays
foys105628292foys
gays87338022gays
ghis85020162ghis
goys86328412goys
guys85019642guys
has67372652_has
hays106138072hays
hes66654202_hes
his66359502_his
hos68364192_hos
hoys107733932hoys
hyp117822462_hyp
hyps125418412_hyps
jays146328342jays
joys146624662joys
kays116032192kays
keys116322162keys
khis117017982khis
lays76043252lays
leys76430182leys
mays96940022mays
mhos95517772mhos
nays75931592nays
ohms95514032ohms
ohs66232312oh_s
pays95940222pays
phis95724902phis
rays77642352rays
rhos76319062rhos
rhus75114052rhus
says75942102says
shays116021432shays
shes75734352shes
shy96728192shy_
soys75233932soys
sways115518462sways
this76027382this
thus76721472thus
thy97022912thy_
toys78036342toys
wabs97337232wabs
wads87343142wads
waes76048602waes
wags86140552wags
wans76452262wans
waps96642082waps
wars78659802wars
was68767562w_as
wats77555882wats
waws106834902waws
way96757662way_
webs96622122webs
weds86628932weds
wees76249122wees
wens76337932wens
wets75940292wets
wha96422072wh_a
wham125321692wham
whams135515642whams
whap125119642whap
whaps135115162whaps
what105434072what
whats117718992whats
whee105429592whee
when105723042when
whens114618762whens
whet105133782whet
whets115019612whets
whew137618782whew
whews145114492whews
whey135018712whey
whid115418872whid
whids125413982whids
whig115516422whig
whigs125612642whigs
whim126220522whim
whims134515332whims
whin105225692whin
whins114922332whins
whip125521842whip
whips134917082whips
whir105519282whir
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whit
whits115923822whits
whiz195919942whiz
who95526772wh_o
whoa106615202whoa
whom127018172whom
whop125520922whop
whops135013932whops
whose114914532whose
whoso11509222whoso
whup125714162whup
whups134210002whups
wigs84931252wigs
wins75949172wins
wis66552332w_is
wiss75630542wiss
wits76044872wits
woes76440662woes
wogs86531402wogs
woks116224902woks
wons74942042wons
woos76238802woos
wops96634152wops
wos66953532w_os
wots76342892wots
wows104633492wows
wry96524702wry_
wuss75219332wuss
wye96331972w_ye
wyes105727502wyes
wyn95921442w_yn
wyns105717032wyns
yays105728912yays

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 Filter178691298720.1401276364.3
2DLD Change Limit298721400.83035990.4
3Display Results1401400.0304666.7
 (SQL Overall)1786911401.000178691.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.