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

265 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
gelatins9341409(None) 
gelatin83514731gelatin_
gelatine93213311gelatine
gelatines102910541gelatines
gelating103015731gelating
gelations102513091gelations
gelatis83313511gelati_s
ceratins102818732ceratins
delating103119602delating
delations102616592delations
elains64919852_ela_ins
elastins82111742_elastins
elating83423082_elating
elations83719122_elations
gelates83219592gelat_es
gelati73814532gelati__
gelatinous1143302gelatinous
gelation93014432gelation
gelatos83111522gelat_os
gratins84119182g_ratins
hematins131714682hematins
keratins122313482keratins
melanins10310382melanins
relating92725442relating
relations92418332relations
relaxins15248682relaxins
zeatins16311732ze_atins
ablating11312003ablating
ablations11311513ablations
aerating92821003aerating
aerations9317903aerations
alanins7315803_alanins
alations82518893_alations
beating104326873be_ating
beatings114113233be_atings
beladies11310423beladies
belaying143110603belaying
belting104119133bel_ting
beltings11369253bel_tings
berating113220763berating
blains84516373_bla_ins
bleating113514503bleating
celadons1137003celadons
ceratin93020163ceratin_
chelating1549363chelating
chelations1539073chelations
cleating113518143cleating
creatins103617513creatins
dealations11311373dealations
debating123213733debating
deflating142610713deflating
deflations1439713deflations
delaine8314793dela_ine
delaines9312963dela_ines
delates83526283delat_es
delation92318083delation
delators92314833delators
delaying133210973delaying
deleting103314423deleting
deletions102610933deletions
dentins83419223de_ntins
derating103222283derating
destains9311813destains
detains83716093deta_ins
dilating102714913dilating
dilations102614453dilations
eating75134403_e_ating
eatings84616443_e_atings
eglantine1044973eglantine
eglantines1143673eglantines
elain55324703_ela_in_
elans55527753_ela__ns
elapids1036503_elapids
elapine9310673_elapine
elastics102710883_elastics
elastin72611843_elastin_
elaterins9410033_elaterins
elaters74420193_elaters
elates65032363_elat_es
elation73620453_elation
elative10312453_elative
elatives1139783_elatives
elfins94810943_el_fins
eloins65419383_el_oins
eluting84115293_eluting
elutions82513053_elutions
emetins9812653_emetins
emptins1179403_emptins
enations83316903_enations
etamins91511833_etamins
fealties1139993fealties
fellating1339253fellating
fellations1338063fellations
fellatios1245503fellatios
felting113515213fel_ting
feltings12317903fel_tings
fetations12511383fetations
flavins1338543_flavins
folacins1337203folacins
gains65729513g__a_ins
galabias1137733galabias
galantine1047333galantine
galantines1145743galantines
galateas937153galateas
galaxies1637173galaxies
galleins9258693galleins
gamins94420053g__amins
gating84826953g__ating
gatings95212823g__atings
gearing92818843ge_aring
gearings10359503ge_arings
geladas936313gela_das
gelant72821673gela__nt
gelants82611443gela_nts
gelate73421263gelat__e
gelated93615643gelat_ed
gelatinize2044843gelatinize
gelatinizes2144843gelatinizes
gelato73812963gelat__o
gelding103911793gel_ding
geldings11316163gel_dings
gelling93219763gel_ling
gelts65924613gel_t__s
gematrias1275393gematrias
gemmating1576443gemmating
gemmations1545003gemmations
genetics11128613genetics
gentians937563ge_ntians
gestating11229983gestating
gestations1139773gestations
getting93316563ge_tting
gigatons1046053gigatons
glacis94012133g_laci_s
glairs75211333g_la_irs
glans65125833g_la__ns
glaring93714883g_laring
glazing183611003g_lazing
glazings19325753g_lazings
gleaming12277933gleaming
gleaning10269323gleaning
gleanings11244643gleanings
gleans75014743glea__ns
gleeting10279173gleeting
gliadins1035193gliadins
gloating102611463gloating
globins10278953g_lobins
glutens8437593g_lutens
glycins1335563g_lycins
gradins93416233g_radins
grains74223093g_ra_ins
gratin74520583g_ratin_
gratine84719193g_ratine
grating93923183g_rating
gratings103910763g_ratings
gratis74819243g_rati_s
greatens9307593greatens
guanins8810013g_uanins
gyrating1337453gyrating
gyrations1336923gyrations
haematins14147753haematins
halations12312393halations
heating114024323he_ating
hemateins1486173hemateins
hematics151712193hematics
hematin121516023hematin_
hematine131614673hematine
hematines141312203hematines
heparins13310123heparins
hepatics15198933hepatics
illations9311393illations
isatins7310773_isatins
jalapins1745623jalapins
kelvins14106563kel_vins
keratin113314153keratin_
lapins84520683__lapins
latens64620213__latens
latina65621143__latina
latinas74416463__latinas
latino64120473__latino
latinos73613803__latinos
lattins74115483__lattins
layins93817653__layins
lealties8310793lealties
lectins92515003le_ctins
legatine91311403legatine
legating102313113legating
legations102711923legations
leptins92412693le_ptins
matins84527783__matins
megatons11279703megatons
melamine12310303melamine
melamines1339763melamines
melanics1237733melanics
melanin9310893melanin_
melatonins1245643melatonins
melting103317753mel_ting
meltons9410923mel_tons
neatens73310403ne_atens
negating102012833negating
negations102811963negations
negatons9299273negatons
oblations1139373oblations
paladins11911003paladins
palatine10316073palatine
palatines11313043palatines
patins87528783__patins
pectins112315233pe_ctins
pelagics1345553pelagics
pelotons1038913pelotons
peltations12311553peltations
pelting102917273pel_ting
pertains102113423pertains
plains85019593_pla_ins
platans93413123_platans
platens94213983_platens
platies93722543_platies
platina94413643_platina
platinas103610313_platinas
plating103823073_plating
platings113611363_platings
pleating112916053pleating
reagins84215643re_agins
realties8514853realties
rebating112418343rebating
redating102620173redating
reflating132514713reflating
reflations13311233reflations
regains84316583rega_ins
regelating1239953regelating
relacing112516043relacing
relaters83218153relaters
relates73731433relat_es
relation82619773relation
relative11313143relative
relatives1239963relatives
relators83316133relators
relaxin14239183relaxin_
relaxing162612633relaxing
relaying122515153relaying
remains94117913rema_ins
remating112322423remating
replating122217403replating
reslating102516993reslating
retains74522253reta_ins
satins64930483__satins
seating84130683se_ating
seatings93614303se_atings
sedating103014113sedating
sedations10311253sedations
sextains15246813sextains
slating83724653_slating
slatings94011723_slatings
solanins8310513solanins
solating9315593solating
solations9814623solations
statins73719773_statins
velamina1345663velamina
venations12311723venations
veratrins1247753veratrins
vexations1937753vexations
volutins1188003volutins
welkins1437173wel_kins
welting113615313wel_ting
weltings12388203wel_tings
zeatin15412823ze_atin_

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622656.51622431.2
3Display Results2652650.1102409.1
 (SQL Overall)1786912657.04625360.6
 
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.