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

183 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
jealous143809(None) 
jealousy1842221jealousy
zealous1637811zealous
jalops15329592j_alops
jealously1944432jealously
jellos134714282jello_s
petalous1058972petalous
sepalous1047522sepalous
zealots1636762zealots
acajous1666483acajous
acaulous1045923acaulous
aeneous739893aeneous
agamous1037933agamous
aloes54933673__aloes
aloud65018073__aloud
amadous1038493amadous
analogs82810453analogs
apetalous1144583apetalous
bayous11411153_bayous
beacons11410733beacons
beanos85516513beano_s
beaus75127113bea__us
beclogs1237073beclogs
becloud1246293becloud
beclouds1345373beclouds
bellows124313303bellows
belons84119413be_lons
belows114614183be_lows
bullous9311663bullous
callous93516603callous
callus85317073_callus
calos74431903_calo_s
cellos84517803cello_s
celoms10412123ce_loms
cephalous1645383cephalous
cerous85821203ce_rous
chylous15107273chylous
deacons10310393deacons
dealers84118613dealers
deals65435343deal__s
decalogs1245633decalogs
delouse839833de_louse
deploys1336523deploys
devious1138523devious
dialogs938103dialogs
emulous937343emulous
etalons739073etalons
famous11412393_famous
felloes104114383felloes
fellows134212433fellows
felons93615763fe_lons
ferrous1049793ferrous
gallous82813953gallous
gallus74313203_gallus
galops94712623_galops
haloes94623863_haloes
halons95720713_halons
halos85230253_halo_s
healers104319463healers
heals85733453heal__s
healths13478753healths
heinous1038853heinous
helloes103717463helloes
hellos95321683hello_s
helos84928063he_lo_s
helots95217703he_lots
jabots1538883j_abots
jacobus1843173j_acobus
jailors14328753jailors
jalaps15299183j_alaps
jalop144212603j_alo_p
jalopy18325863j_alopy
jalousie1543143j_alousie
jatos125116823j_ato_s
jealousies1742363jealousies
jeans126022113jea__ns
jehus15488573je__hus
jellies143816533jellies
jello126716273jello__
jells125522163je_l_ls
jerboas1636163jerboas
jetlags1533863jetlags
jetons134512613je_tons
jetsoms16124723jetsoms
jettons1437273jettons
joyous16276763j_oyous
leprous938843leprous
meadows1337333meadows
mealies92821933mealies
meals75933373meal__s
meatus85112923mea_tus
megalops1356123megalops
melanous1048603melanous
mellows123812233mellows
melons84117713me_lons
meous76120063me__ous
merlons93311273merlons
merlots92710123merlots
miaous8511693mia_ous
nebulous1045093nebulous
nervous1037143nervous
palpus104210283_palpus
parlous9414293parlous
parous84024163_parous
peals75235493peal__s
pedalos10329703pedalo_s
pelorus939273pe_lorus
peplos101211543peplo_s
peplus10138343pepl_us
perilous10310693perilous
petrous92714423petrous
phallus1236063phallus
pilous84717753_pilous
ramous8417113_ramous
readout8615513readout
readouts938903readouts
reales64934123real_es
reallots837993reallots
realms84913493real_ms
reals55038653real__s
realtors82811683realtors
rearouse839363rearouse
reasons72514943reasons
reavows1335273reavows
reflows13258983reflows
regloss8218023regloss
reglows11288843reglows
replots93412633replots
replows12329703replows
sajous13310583_sajous
salols64017873_salols
salons63823693_salons
seadogs958643seadogs
sealers74323553sealers
seals54839693seal__s
seasons72614233seasons
sedulous946133sedulous
sellout7313583sellout
sellouts837493sellouts
serious73616283serious
serous65023563se_rous
setous64917373se_tous
setulous846913setulous
shaloms1288983shaloms
slaloms9106543slaloms
talcous939483_talcous
talons64019433_talons
talus55423263_tal_us
teahouse1146073teahouse
teals56234133teal__s
teapots939053teapots
teapoys1235963teapoys
tedious838443tedious
teflons1036543teflons
telos55424523te_lo_s
tenuous738483tenuous
thallous1136523thallous
thallus1035603thallus
unzealous1842733unzealous
uranous7310733uranous
valgus1047103_valgus
valors93413773_valors
valour93010373_valour
valours10248743_valours
vealers103214293vealers
veals84926193veal__s
velour9328763ve_lour
velours10278083ve_lours
venous93713193ve_nous
venulous1145713venulous
villous102810023villous
walrus956433_walrus
weakons14287803weakons
wealds10459103weal_ds
weals85428743weal__s
wealths13365813wealths
weapons12278603weapons
weasons102310583weasons
weblogs1334223weblogs
yellows13329603yellows
zealot15313473zealo_t
zealously2144303zealously
zeals145320853zeal__s

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.1561145455.1
2DLD Change Limit1340271837.11018850.5
3Display Results1831830.0603050.0
 (SQL Overall)1786911837.32624391.3
 
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.