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

200 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
realities931631(None) 
realties8514851real_ties
regalities11410591regalities
analities9715872analities
dualities10310442dualities
fealties1139992feal_ties
idealities1148782idealities
irrealities1146212irrealities
lealties8310792leal_ties
legalities1148912legalities
oralities91214122oralities
ovalities12119802ovalities
penalities121313472penalities
qualities18311222qualities
rarities8316332r_arities
realises82420182reali_ses
realizes173116842reali_zes
ruralities1048572ruralities
unrealities1147532unrealities
venalities131510722venalities
abilities11714143abilities
agilities10810973agilities
alibies9313323__alibies
amities9317383__amities
anilities9516003anilities
auralities10410223auralities
axialities1747733axialities
banalities1249813banalities
beasties102514653bea_sties
beatifies1459283beatifies
beauties10229523bea_uties
brevities1446423bre_vities
brutalities1345443brutalities
calvities1438943_calvities
canities101519263_canities
carnalities1348773carnalities
cavities131412613_cavities
cecities12312043ce_cities
charities14312743charities
clarities11312483clarities
coalifies1439113coalifies
coevalities1646803coevalities
credulities1444133credulities
dealates92716683dealat_es
debilities13411293debilities
deities82621923de__ities
dekalitres1542963dekalitres
densities10310793densities
dentalities1249543dentalities
edacities1247773edacities
egalites9310503egalit_es
elites66027123_e_lit_es
enmities10611353_enmities
entities8617413_entities
equalities1949013equalities
equities17310773_equities
falsities1248133_falsities
fatalities1349443fatalities
feracities1548713feracities
ferities111416713fe_rities
feudalities1545343feudalities
finalities1349903finalities
formalities16137823formalities
frailties1245853frailties
frugalities1544163frugalities
genialities12148643genialities
gravities1338303gravities
halites103221193_halit_es
hearties11315413hea_rties
hyalites14208833hyalit_es
inanities9312443inanities
jellifies1946263jellifies
jollities1647873jollities
laities7320343_la_ities
laxities1539093_laxities
lenities8315943le_nities
lethalities1446413lethalities
levities11310713le_vities
linealities1148223linealities
localities1259733localities
mealies92821933meal__ies
mealtimes1345243mealtimes
megacities1546673megacities
mentalities13410023mentalities
modalities13138813modalities
molalities121110283molalities
moralities121111923moralities
mortalities1348423mortalities
nasalities1048563nasalities
natalities10410663natalities
nodalities11138583nodalities
normalities13148113normalities
nullities949353nullities
opacities1347943opacities
parities10522973_parities
pearlites1138233pearlit_es
pelites93821993pe_lit_es
penalties11139513penal_ties
penlites10312273penlit_es
perlites10316363perlit_es
polities102722343_polities
predacities1646913predacities
primalities1548293primalities
qualifies2147503qualifies
rallies73823343r_al_lies
ramifies13310503r_amifies
ramilies10311833r_amilies
rapacities1446543rapacities
rarifies11311933r_arifies
rascalities1347223rascalities
ratifies11313513r_atifies
ratites74920683r_atit_es
raucities1148163raucities
readies83324713rea__dies
reales64934123real___es
realigned1145333realigned
realigns936253reali_gns
realise73021813reali_se_
realised92214533reali_sed
realiser82512563reali_ser
realisers9248323realisers
realising10313173realising
realisms102212163reali_sms
realistic1148553realisti_c
realists83014843reali_sts
reality10313573realit__y
realize162717083reali_ze_
realized182514223reali_zed
realizer172412113reali_zer
realizers18237933realizers
realizing19313813realizing
realter73716313real_t_er
realters83614043real_ters
realtors82811683real_tors
reapplies1344913reapplies
recites93524583re_cit_es
reclines103718543recli_nes
reclothes1445643reclothes
rectifies14310813rectifies
redlines93916083redli_nes
reedifies1347323reedifies
reflates113115663reflat_es
reflies104418533refl__ies
reifies104218283re__ifies
relates73731433re_lat_es
relatives1239963relatives
relies65036423re_l__ies
relieves114210393re_lieves
relines75331323re_li_nes
reliques1736903re_liques
relishes11311953re_lishes
relives104619443re_li_ves
repacifies1745653repacifies
replates102919273replat_es
repletes102812473replet_es
replevies1465493replevies
replies94521043repl__ies
requalifies2344353requalifies
requites171511763requit_es
resalutes947433resalut_es
resites74027793re_sit_es
reslates83619503reslat_es
respites10513243respit_es
retaliates1049093retaliates
retallies939373retal_lies
reties65436193re___ties
retitles83612593re_titles
reunifies1247583reunifies
reunites8312473reunit_es
rewrites11311063rewrit_es
royalties1244913royal_ties
ruralites947943ruralit_es
salifies11314793_salifies
salties73725773_sal_ties
sanities81219773_sanities
sealeries9313133sealeries
sedulities1147543sedulities
senilities10312993senilities
sexualities1857403sexualities
sodalities11138703sodalities
suavities1248413suavities
tenacities1248583tenacities
tensities9311333tensities
tenuities949763tenuities
tonalities101711733tonalities
totalities101210783totalities
treaties8316983trea__ties
uralites82112723uralit_es
urbanities1245333urbanities
utilities9610803utilities
vanities111414493_vanities
velites103417303ve_lit_es
velleities1344933velleities
venialities14168933venialities
veracities1549503veracities
verities111418043ve_rities
vitalities1349093vitalities
vocalities1549393vocalities
zealotries1944353zealotries
zeolites1738383zeolit_es

Search took 9 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 Filter1786911486410.440406115.9
2DLD Change Limit1486412008.00018580.1
3Display Results2002000.0762631.6
 (SQL Overall)1786912008.51620983.0
 
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.