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

245 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
citrated11271225(None) 
citrate92216801citrate_
citrates102315091citrates
nitrated92213151nitrated
titrated92611681titrated
acierated1238282acierated
castrated1239512castrated
cerated103922472c_erated
ciliated11510952ciliated
cirrate92413492cirrate_
crated94827772c__rated
cultrated1248222cultrated
curated104717582c_urated
disrated10915572disrated
filtrated1345962filtrated
iterated91213822_iterated
librated113110312librated
migrated121110512migrated
misrated111315382misrated
nitrate72017012nitrate_
nitrates82516222nitrates
outrated92219312outrated
picrated132110112picrated
pirated102515612pi_rated
situated938032situated
titrate72215572titrate_
titrates82314662titrates
vibrated14228392vibrated
vitiated12289222vitiated
acerated113113983acerated
acetated112010683acet_ated
acierate10311813acierate_
acierates11310813acierates
activated1567883activated
actuated1138743actuated
aerated85322373_aerated
agitated1038413agit_ated
airted74214503ai_r_ted
arbitrated13125523arbitrated
attracted1246073attracted
attrited947373attrited
aurated83817793_aurated
berated104422133_berated
betrayed1436303betrayed
biparted1335133biparted
bitted94418483bit__ted
borated104116363_borated
calibrated1545653calibrated
capitated14159043capit_ated
carate84734003c_arate_
carates95630613c_arates
carted98631443c_ar_ted
caseated11310713caseated
castrate10313863castrate_
castrater1148533castrater
castrates11312683castrates
catenated1238913catenated
catted95422473cat__ted
caudated1238063caudated
caveated1439133caveated
cavitated15177353cavit_ated
cerate84829463c_erate_
cerates95428253c_erates
charted135116853char_ted
cheated134416343c_heated
chelated142610493chelated
ciliate9514603ciliate_
ciliates10413453ciliates
circled1237583ci_rcled
cirriped1344183cirriped
cisted95217523ci__sted
citadel1044383cit_adel
citator9310123cit_ator
cited84421953ci___ted
citied94014143cit__ied
citified1438253citified
citral81113893citra__l
citrals91111673citra_ls
citrine92514023citrine_
citrines102513133citrines
citruses1037483citruses
cityfied1742703cityfied
cleated103417843c_leated
coated94927043c__oated
cocreated142710093cocreated
cogitated1346323cogit_ated
collated113615063collated
combated1539823combated
contracted1549823contracted
contrasted1348583contrasted
corraded12128293corraded
courted103514923cour_ted
crafted13419773c__rafted
craned96121653c__raned
craped116120533c__raped
crate76537403c__rate_
crater85026643c__rater
crates85736063c__rates
craved125417773c__raved
crazed184714453c__razed
created104323453c_reated
cremated133412963cremated
crenated113013913crenated
crispated1445023crispated
cristated1247423cristated
cultrate10310873cultrate_
cuneated11310103cuneated
curate85226243c_urate_
curates95323833c_urates
curtate9312643curtate_
cuspated1335913cuspated
cutwater1344833cutwater
denitrated1298033denitrated
derated93623503_derated
detracted1357793detracted
dictated1239203dictated
dilated93115823di_lated
disrate81418523disrate_
disrates91118153disrates
distracted1448873distracted
emigrated1347073emigrated
entreated10310973entreated
estated83715573est_ated
estrayed1236393estrayed
estreated1039563estreated
extracted1946723extracted
filiated12610083filiated
filtrate1148223filtrate_
filtrates1247733filtrates
fitted104716663fit__ted
fixated1835533fi_xated
girted83912873gi_r_ted
gitted84015053git__ted
grated84523923__grated
guttated10266873guttated
gyrated12428413_gyrated
hydrated16216953hydrated
ideated9310973_ideated
imitated1138263imit_ated
initiated10510113initiated
intreated10312663intreated
iodated9310023_iodated
irate55627983_i_rate_
irater65218353_i_rater
iterate71119113_iterate_
iterates81317823_iterates
kitted115114833kit__ted
liberated1299473liberated
librate93214233librate_
librates103412953librates
ligated92414143li_gated
lineated9711063lineated
liquated1835493liquated
literate81216893literate_
literates91415653literates
litigated1146563litigated
lustrated1037963lustrated
lyrated11388473_lyrated
maturated1249163maturated
micturated1584993micturated
migrate101314173migrate_
migrates111112853migrates
misdated121211123misdated
mismated131111333mismated
misrate91319143misrate_
misrates101318243misrates
mistraced1439453mistraced
mistreated1348423mistreated
mitigated1347083mitigated
mitred94414343mitr__ed
mutated102712253mut_ated
narrated9310323narrated
nictated1137793nictated
nidated939863ni_dated
nitrator849553nitrator
nitrided10276753nitrided
nitrite72314463nitrite_
nitrites82313453nitrites
nonrated9310843nonrated
notated82713663not_ated
nutated83113423nut_ated
obturated1245953obturated
operated11512223operated
orated74221503__orated
outdated1012513193outdated
outraced112414203outraced
outraged102313103outraged
outrate72323183outrate_
outrates82421373outrates
outraved122511923outraved
patriated1238533patriated
picrate112014143picrate_
picrates122013213picrates
pileated112711133pileated
pinnated11338553pinnated
pirate82322883pi_rate_
pirates93020333pi_rates
pitted94319593pit__ted
prated94924923__prated
prorated11513713prorated
rated65441383___rated
recrated112918613recrated
regrated102816333regrated
reiterated11410153reiterated
retraced111413023retraced
retracted12410953retracted
retreated10312623retreated
rotated82715293rot_ated
satiated9311603satiated
saturated1038993saturated
serrated92513433serrated
sinuated938413sinuated
situate7410783situate_
situates8310373situates
started84217323_started
stated75427833_st_ated
strafed114413333_strafed
straked125415343_straked
strawed114813613_strawed
strayed114513283_strayed
striated93414153_striated
tarted74923373__tarted
tartrated1096643tartrated
teated74924023__teated
tiaraed837053tiara_ed
titivated1345443titivated
titrator858543titrator
traced94821583__traced
traded85717683__traded
treated83618703__treated
tritiated1047523tritiated
triturated1145073triturated
ultrared936663ultrared
uncrated11416313uncrated
unrated82621553_unrated
untraced112413243untraced
untreated10312903untreated
uprated103213323_uprated
vibrate122811523vibrate_
vibrates132210613vibrates
violated1237883violated
vitiate103412953vitiate_
vitiates112311433vitiates
vittate10409733vittate_
witted104216813wit__ted

Search took 9 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.453394461.4
2DLD Change Limit1461622457.45319611.2
3Display Results2452450.1102227.3
 (SQL Overall)1786912458.01622291.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.