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

153 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
gelatines10291054(None) 
gelatine93213311gelatine_
gelatins93414091gelatin_s
delaines9312962dela_ines
eglantines1143672eglantines
elatives1139782_elatives
galantines1145742galantines
gelates83219592gelat__es
gelatin83514732gelatin__
gelating103015732gelatin_g
gelatinizes2144842gelatinizes
gelatinous1143302gelatinous
gelations102513092gelations
gelatis83313512gelati__s
hematines141312202hematines
melamines1339762melamines
palatines11313042palatines
relatives1239962relatives
ablatives1445503ablatives
alanines8314803_alanines
astatines9310343astatines
beatings114113233be_atings
beladies11310423beladi_es
beltings11369253bel_tings
beltlines1135963beltlines
betaines10313293beta_ines
calamines13312223calamines
celandines1344843celandines
celestines12136893celestines
ceratins102818733ceratin_s
creatines112814433creatines
delaine8314793dela_ine_
delates83526283delat__es
delating103119603delatin_g
delations102616593delations
dentines93418403de_ntines
destines93619663de_stines
eatings84616443_e_atings
eglantine1044973eglantine_
eglateres1044453eglateres
elains64919853_ela_in_s
elapine9310673_elapine_
elastins82111743_elastin_s
elates65032363_elat__es
elating83423083_elatin_g
elations83719123_elations
elative10312453_elative_
emetines10611053_emetines
enamines101112133_enamines
etamines101611813_etamines
examines17128793_examines
fealties1139993fealti_es
felines104718073fel__ines
felstones1246963felstones
feltings12317903fel_tings
flamines13311643_flamines
flatlines12268433_flatlines
flavines1437893_flavines
galantine1047333galantine_
galaxies1637173galaxi_es
gallamines1345493gallamines
gamines103618463g__amines
gatings95212823g__atings
gearings10359503ge_arings
gelants82611443gela__nts
gelate73421263gelat__e_
gelated93615643gelat__ed
gelati73814533gelati___
gelatinize2044843gelatinize
gelatinized2254213gelatinized
gelation93014433gelati_on
gelatos83111523gelat__os
geldings11316163gel_dings
gemstones1245563gemstones
genitives1346663genitives
gentiles93713523ge_ntiles
glacises1138513g_lacises
glaires84010143g_la_ires
glaives11347833g_la_ives
glariness1038553g_lariness
glassines10278043g_lassines
glaziness1935753g_laziness
glazings19325753g_lazings
gleanings11244643gleanings
gliadines1144773gliadines
glycines1445083g_lycines
gradines103615253g_radines
gratine84719193g_ratine_
gratinee93710783g_ratinee
gratinees10307323g_ratinees
gratings103910763g_ratings
gratins84119183g_ratin_s
gregarines1244783gregarines
grenadines1245173grenadines
guanines989773g_uanines
hematine131614673hematine_
hematins131714683hematin_s
hematites141510793hematites
hepatizes2347823hepatizes
hexamines2146203hexamines
illatives1245523illatives
isatines8310663_isatines
keratins122313483keratin_s
ketamines15177033ketamines
latices9313763__latices
latinas74416463__latinas
latinos73613803__latinos
latrines8515013__latrines
lawines103313563__lawines
lealties8310793lealti_es
legatine91311403legatine_
levantines1364223levantines
mealtimes1345243mealtimes
meatiness11311183me_atiness
melamine12310303melamine_
melanins10310383melanin_s
melanites11410733melanites
melanizes20410383melanizes
negatives1346583negatives
palatine10316073palatine_
patines95225763__patines
pectines121914683pe_ctines
pelerines11311843pelerines
platanes102711883_platanes
platies93722543_plati_es
platinas103610313_platinas
platings113611363_platings
ratines75328583__ratines
realties8514853realti_es
relates73731433relat__es
relating92725443relatin_g
relations92418333relations
relative11313143relative_
relaxins15248683relaxin_s
relines75331323rel__ines
relumines1147413relumines
retines75134673re__tines
saltines82917793sal_tines
seatings93614303se_atings
sedatives1346153sedatives
serotines9312073serotines
sestines82717243se_stines
slatiness92511363_slatiness
slatings94011723_slatings
smaltines1136993smaltines
solanines9310083solanines
teatimes1039443te_atimes
telamones1146213telamones
velarizes2148643velarizes
veratrines1347263veratrines
volatiles1246133volatiles
weltings12388203wel_tings
zeatins16311733ze_atin_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 Filter1786911486410.420425454.8
2DLD Change Limit1486411536.83021763.0
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.31324434.7
 
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.