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

254 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
gelations10251309(None) 
delations102616591delations
elations83719121_elations
gelatins93414091gelati_ns
gelation93014431gelation_
relations92418331relations
ablations11311512ablations
aerations9317902aerations
alations82518892_alations
chelations1539072chelations
dealations11311372dealations
deflations1439712deflations
delation92318082delation_
deletions102610932deletions
dilations102614452dilations
elation73620452_elation_
elutions82513052_elutions
enations83316902_enations
fellations1338062fellations
fetations12511382fetations
gelatin83514732gelati_n_
gelatine93213312gelati_ne
gelatines102910542gelatines
gelating103015732gelati_ng
gelatinous1143302gelatinous
gelatis83313512gelati__s
gelatos83111522gelat_o_s
gemmations1545002gemmations
gestations1139772gestations
gyrations1336922gyrations
halations12312392halations
illations9311392illations
legations102711922legations
negations102811962negations
oblations1139372oblations
peltations12311552peltations
reflations13311232reflations
relation82619772relation_
sedations10311252sedations
solations9814622solations
venations12311722venations
vexations1937752vexations
ablation10312433ablation_
ablutions1146603ablutions
acylations1547603acylations
adnations1039753adnations
adulations11310123adulations
aeration8319933aeration_
agitations11310063agitations
agnations10310033agnations
alation72920553_alation_
angulations1268053angulations
aviations12311553aviations
betatrons1145083betatrons
bevatrons1443713bevatrons
cations94524143__cations
celadons1137003cela_dons
ceratins102818733cerati_ns
cessations1256473cessations
chelation1439963chelation_
ciliations121111003ciliations
citations11312503citations
clarions10310493_clarions
collations12312853collations
conations111318903conations
congelations1549733congelations
creations112614543creations
cremations14410713cremations
crenations12511693crenations
dealation10313003dealation_
deflation13310653deflation_
delating103119603delati_ng
delators92314833delat_ors
delegations1348033delegations
deletion92011973deletion_
delusions1037053delusions
demotions1258443demotions
dentations11413633dentations
depilations14310903depilations
depletions1355743depletions
desolations12310593desolations
deviations14311163deviations
devotions1356593devotions
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
editions9310403_editions
egestions1046703egestions
elains64919853_ela_i_ns
elastins82111743_elasti_ns
elating83423083_elati_ng
elatives1139783_elatives
elections112414973_elections
elevations1338633elevations
elisions82210423_elisions
elusions82610083_elusions
elution72913823_elution_
emotions10610283_emotions
emulations12310943emulations
enation73419233_enation_
epilations12311713epilations
equations1839493equations
erasions8310983_erasions
evasions1136543_evasions
exactions1838923_exactions
fellation1238843fellation_
fellatios1245503fellatio_s
fetation11613143fetation_
filiations13119093filiations
fixations1936353fixations
flatirons1244483_flatirons
flections14239213flections
foliations1399943foliations
gabions102410053g__abions
gelates83219593gelat__es
gelati73814533gelati___
gelato73812963gelat_o__
geminations14139263geminations
gemmation1445963gemmation_
generations12311423generations
gentians937563ge_ntians
geraniols1044743geraniols
gestation10310663gestation_
gigatons1046053gigat_ons
gleizations21135283gleizations
gluttons944273g_luttons
gnathions1343303g_nathions
gradations1286863gradations
gratins84119183g_rati_ns
gumptions1443773gumptions
gustations1147233gustations
guttations1145593guttations
gyration1237763gyration_
halation11313853halation_
hellions11310023hel_lions
hematins131714683hemati_ns
himations1438803himations
ideations1039903ideations
illation8311943illation_
inflations13310323inflations
iodations1039113iodations
isolations10310693isolations
iterations10413823iterations
kations114013663__kations
keratins122313483kerati_ns
lallations1038743lallations
latinos73613803__latinos
lavations1238973lavations
laxations1637623laxations
lections102413843le_ctions
legation92412933legation_
lenitions939473lenitions
libations112510443libations
ligations102111993ligations
lobations11219613lobations
locations112512743locations
lotions74614763__lotions
lunations9310723lunations
luxations1637273luxations
malathions1543873malathions
mediations13310983mediations
megatons11279703megat_ons
melanins10310383melani_ns
meltons9410923mel_t_ons
mentations12312583mentations
mentions10312893me_ntions
mutations111211453mutations
natations91412493natations
nations74720563__nations
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nervations1359483nervations
nidations1039213nidations
notations91512973notations
novations12139003novations
nutations91411763nutations
oblation1039863oblation_
operations12312953operations
orations81515803_orations
ovations11149263_ovations
ovulations1337973ovulations
palmations1438733palmations
palpations1437653palpations
peculations15310283peculations
pelotons1038913pelot_ons
peltation11312963peltation_
petitions11511083petitions
platoons1038683_platoons
potations111615073potations
predations13812153predations
pulsations1236373pulsations
pupations1338123pupations
rations74123433__rations
reactions11711713reactions
recautions1247813recautions
redactions1359133redactions
reflation12412333reflation_
regulations12310713regulations
relating92725443relati_ng
relational1047713relational
relatives1239963relatives
relators83316133relat_ors
relaxations1845643relaxations
relaxins15248683relaxi_ns
relegations1248973relegations
relictions12310023relictions
religions1086603religions
relocations13311143relocations
remotions1149703remotions
repletions1247473repletions
restations10315843restations
revelations14410303revelations
rogations101510823rogations
rotations91613843rotations
saltations10310623saltations
salvations1338133salvations
scalations1239783scalations
sections102714703se_ctions
sedation9312453sedation_
seditions1039013seditions
selections12310873selections
sensations1059853sensations
seriations10316683seriations
serrations10313103serrations
siltations1038553siltations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
stations82415223_stations
sublations12410113sublations
sudations1039903sudations
sulcations1289583sulcations
sulfations13107813sulfations
taxations1636863taxations
telethons1246023telethons
tevatrons1244003tevatrons
ululations1037143ululations
vacations141910553vacations
vallations1339093vallations
valuations1348783valuations
vegetations1547323vegetations
venation11513503venation_
vernations13310333vernations
vexation1838783vexation_
vexatious1944103vexatious
violations1337963violations
vocations141911423vocations
volitions1288663volitions
volutions12108393volutions
zeatins16311733ze_ati_ns
zonations18139313zonations

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 Filter1786911486410.466383457.1
2DLD Change Limit1486412546.59622535.0
3Display Results2542540.1102309.1
 (SQL Overall)1786912547.17224915.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.