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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

171 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
nailset731197(None) 
nailsets834551nailsets
nailed74021492nail_ed
nailer64119362nail_er
nails55730402nails__
naivest10309472naivest
ablest84721833_ablest
aglet65534143_agl_et
aiglet74224193_aiglet
aigret73720023_aigret
ailed66240283_ail_ed
ailment9314233_ailment
ails45654713_ails__
airest63825263_airest
aisle55223193_aisle_
aisled74516183_aisled
aisles64721143_aisles
alist56136783_alis_t
anile54634463anil_e_
anils56326723anils__
anise55129703ani_se_
anises64826693ani_ses
anklet105618733ankl_et
asset55932263_a_sset
avoset9315673_avoset
backset15314193backset
bailed94726653bail_ed
bailee84526013bail_ee
bailees93914383bailees
bailer85425253bail_er
bailey115015673bail_ey
bailie83818363bailie_
bailies94120203bailies
bailment1249183bailment
bailout9414133bailout
bails75933523bails__
bailsmen1244623bailsmen
ballet84733973ba_llet
basset85225383ba_sset
billet86029723_billet
cablet104429463cabl_et
callet84536763ca_llet
camlet104426583caml_et
caplet104226813capl_et
dailies84219263dailies
daises74318983dai_ses
eaglet73722583eagl_et
evilest10310473evilest
failed105421603fail_ed
faille93414743faille_
failles102914133failles
fails85631483fails__
fainest10417703fainest
fairest10412293fairest
false84818123fa_lse_
falser93912413fa_lser
falsest10310013fa_lsest
filet85540163_fil_et
fillet95027083_fillet
filmset1257513_filmset
frailest1139493frailest
gainst74914703gains_t
gallet73630853ga_llet
grilse7399503grilse_
grilses8319153grilses
hailed104122743hail_ed
hailer94720343hail_er
hails85231643hails__
hairnet10911703hairnet
halest94823273ha_lest
hamlet113722793haml_et
handset113016823handset
hardset113415833hardset
harslet10315653harslet
haslet93222713hasl_et
inset54430863__inset
islet54527553__islet
jailed144917423jail_ed
jailer134316683jail_er
jails125422943jails__
kails95525213kails__
kaiser103610373kai_ser
maile75232223mail_e_
mailed95326753mail_ed
mailer84724183mail_er
mailes84329113mail_es
maillot9312173maillot
mailmen1137273mailmen
mails76037783mails__
maist75535683mai_s_t
mallet84433053ma_llet
millet84030743_millet
misset85028153_misset
naiades838213naiades
naifs87617423naifs__
nail45838653nail___
nailers73215893nailers
nailhead1243983nailhead
nailing83419963nailing
naive85116213nai_ve_
naiver94311353nai_ver
naives94914223nai_ves
naivete1055663nai_vete
naivety1344283nai_vety
naled65525053na_l_ed
napless93110283napless
nausea637313na_usea
neist54628443nei_s_t
nicest82315663n_icest
nidget83715643n_idget
nilled73919453n_illed
nils46132453n_ils__
nisei54214353n_i_sei
noblest93613563noblest
noils55024333noils__
noise55723733noi_se_
noised75416233noi_sed
noises65021853noi_ses
nutlet64220563nutl_et
pails75833063pails__
paise75028333pai_se_
paisley1235553paisley
palest83926223pa_lest
palet74650803pa_l_et
paliest93021613paliest
pallet84232653pa_llet
quillet162713233quillet
railed74727543rail_ed
railer64524933rail_er
rails55937403rails__
raise54828053rai_se_
raised76120333rai_sed
raiser66620103rai_ser
raises64826543rai_ses
rillet64828853_rillet
sailed74327763sail_ed
sailer63526103sail_er
sails55738103sails__
sallet63734543sa_llet
samlet84126563saml_et
skillet113512153skillet
snailed83811923snail_ed
snails64816653snails__
tablet84227643tabl_et
tailed74424663tail_ed
tailer63823733tail_er
taille63116923taille_
tailles72516473tailles
tails55634193tails__
tallest7317093tallest
tasset65925313ta_sset
toilet66228093toil_et
twinset1039373twinset
vailed104619293vail_ed
vails85825933vails__
vainest10315763vainest
valet84337873va_l_et
valise92917643valise_
valises103516263valises
valse85117523va_lse_
valses94514613va_lses
varlet9423503varl_et
vilest9416843_vilest
wadset10314303wa_dset
wailed104823593wail_ed
wailer93720323wail_er
wails86631483wails__
waist86132383wai_s_t
wallet93327093wa_llet
whilst1239143whils_t
willet95124833_willet

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271717.25018486.5
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.71923149.5
 
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.