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

264 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
creatine10341741(None) 
creatin93618131creatin_
creatines112814431creatines
creating113921951creating
creatins103617511creatins
creative132812801creative
cavatine13310322cavatine
ceratin93020162ceratin_
ceratins102818732ceratins
cheating144014522cheating
cleating113518132cleating
crating103725202cr_ating
creaking153414122creaking
creaming133413142creaming
creasing113314442creasing
create85126382creat__e
creatinine1245072creatinine
creation102816512creation
creations112614542creations
creatives14279692creatives
creature1038732creature
cremating14312192cremating
cresting114017042cresting
cretin82917912cre_tin_
cretins93216422cre_tins
gratine84719192gr_atine
ratine65131822_r_atine
retine66237332_re_tine
treating92519612treating
treatise8311102treatise
aerating92821003aerating
argentine1047893argentine
astatine8313533astatine
beating104326873_beating
berating113220763berating
betaine9413783_betaine
bleating113514503bleating
breading123515463breading
breadline1246273breadline
breaking153914253breaking
breaming133612513breaming
breasting1239583breasting
breathe123711843breat_he
breathing15218373breathing
calamine12314033calamine
canine83826703c__anine
carabine12412383carabine
carnitine1178573carnitine
caseating12311743caseating
cavatina1347333cavatina
caveating1539293caveating
ceasing104118263c_easing
celestine11147943celestine
centile94217183c_entile
centime114513033c_entime
ceramide1347973ceramide
cerate84829463cerat__e
certain92612213certain_
certainer1146193certainer
cervine122610803c_ervine
cetane8315283c_e_tane
chaine115119223c_ha_ine
cheapie1437563cheapi_e
chelating1549353chelating
cleaning113112383cleaning
clearing113014883clearing
cleaving141389683cleaving
clefting14347583clefting
coating103525313c_oating
cobaltine13135613cobaltine
cocaine111315173coca_ine
cocreating15310293cocreating
conative131214623conative
corelating13511583corelating
craaling112711353craaling
crafting143710173crafting
crane75331603cr_a__ne
craning103620303cr_aning
craping124018713cr_aping
crate76537403cr_at__e
craton84517193cr_aton_
cratons94316033cr_atons
craving134015733cr_aving
crazing193914583cr_azing
creakier14328333creakier
creakily1735393creakily
creakiness1645963creakiness
creamier12319063creamier
creamily1536363creamily
creaminess1446203creaminess
crease85519573crea__se
creasier103210193creasier
creatable1339563creatable
created104323453creat_ed
creates95225203creat_es
creatinines1344043creatinines
creatively1846673creatively
creator93714443creat_or
creators102814413creators
creatures1138413creatures
crediting1338843crediting
creeling113513363creeling
creepie1137483creepi_e
creeping133310103creeping
cremains1238693cremains
cremate113816183cremat__e
cremation13511643cremation
cremations14410713cremations
cremini11229063cre_mini
crenate93317113crenat__e
crenation11412923crenation
crenations12511693crenations
crenature1145753crenature
creolise1037863creolise
creolize1947183creolize
creping122913653cre_ping
crescive1545283crescive
crestings12298043crestings
cretic102816283cre_ti_c
cretics112911653cre_tics
cretonne1044363cretonne
crevice1436153cre_vice
crewing133212633cre_wing
crimine112413473cr_imine
croaking153712163croaking
croceine1248033croceine
crocine11314153cr_ocine
crostini1038293crostini
crostino1038883crostino
crusting113612793crusting
curarine10610713curarine
curating11314293curating
curative13310403curative
curetting1236573curetting
cyanine122911513c_yanine
cystine1239333c_ystine
dentine83320243_dentine
derating103222283derating
destine83719953_destine
dreading113712803dreading
dreaming124011063dreaming
dreamtime1442343dreamtime
eating75134403__eating
emetine9712943eme_tine
erectile1039513erectile
erecting112415063erecting
erective13311833erective
ergative1238973ergative
freaking163611453freaking
fretting122711523fretting
gelatine93213303gelatine
gradine93317033gr_adine
gratin74520583gr_atin_
gratinee93710783gr_atinee
grating93923183gr_ating
gratins84119183gr_atins
greasing102811393greasing
greaten83610643greaten_
greatened1144583greatened
greatens9307593greatens
greeting103112353greeting
gregarine1144783gregarine
grenadine1145643grenadine
heating114024323_heating
hematine131614673hematine
ideating10311703ideating
ideative1238573ideative
isatine7311763_isatine
keratin113314153keratin_
keratins122313483keratins
legatine91311403legatine
ocreate93711743ocreat__e
orating83520323or_ating
orective1339353orective
palatine10316063palatine
patine85328123__patine
pleating112916053pleating
praline93019743pr_aline
prating103424453pr_ating
preacting142412533preacting
preattune1143573preattune
precative16312573precative
predating13514653predating
prentice121012353prentice
prestige11310733prestige
pristine10313503pristine
rapine85023083_r_apine
ratines75328583_r_atines
rating74938703_r_ating
ratite65022423_r_atite
ratline74517803_r_atline
ravine95522223_r_avine
reacting113317893_reacting
reactive13310473_reactive
reading93327213_reading
reagin74915533_reagin_
reagins84215643_reagins
realise73021813_realise
realize162717083_realize
reaming103924013_reaming
reaping103621213_reaping
rearing83128783_rearing
reaving113820533_reaving
rebating112418343_rebating
recline94020493_recline
recreating131214583recreating
recreative1549023recreative
redating102620173_redating
redline84218833_redline
refine95225693_re_fine
relating92725443_relating
relative11313143_relative
reline65434353_re_line
remating112322413_remating
renting84026853_renting
repine85627813_re_pine
reptile93914083_reptile
reshine102816943_reshine
resting85031183_resting
restive10315933_restive
retain64523283_retain_
retained93016093_retained
retainer82913813_retainer
retains74522253_retains
retene69224273_re_tene
retie55735303_re_ti_e
retile65929673_re_tile
retime85321803_re_time
retina65023383_re_tina
retinae75517333_re_tinae
retines75134673_re_tines
retint65633443_re_tint
retinue75414843_re_tinue
retire64927013_re_tire
retting83425883_retting
retune69121953_re_tune
rexine134719443_re_xine
routine72615903_routine
screaking16228243screaking
screaming14217833screaming
seating84130683_seating
serotine8313573serotine
sestine73017923_sestine
sonatine8313323sonatine
stearine8311903stearine
steatite8310583steatite
sweating123213023sweating
teatime9310083_teatime
threating131010053threating
treading103515333treading
treaties8316983treaties
treatises9310373treatises
trephine1338933trephine
triazine1738503triazine
uncreating13310473uncreating
uncreative1547533uncreative
veratrine1247753veratrine
wreaking163010213wreaking
wreathe13339053wreat_he
wreathen14256143wreathen
wreathing16266313wreathing
wresting123811833wresting
zeatin15412823_zeatin_
zeatins16311733_zeatins

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.440406115.9
2DLD Change Limit1461622646.86021306.4
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.41024114.8
 
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.