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

496 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
ideates831373(None) 
ideate7313681ideate_
ideated9310971ideated
creates95225202creates
dates65639152_d_ates
deaths105914442_deaths
deaves105319532_deaves
debates103718532_debates
delates83526282_delates
derates84028892_derates
dilates83220662dilates
idealess935652idealess
ideals75012502idea_ls
ideas65919012idea__s
ingates82716912ingates
inmates92715782inmates
iodates8312902iodates
iterates81317822iterates
nidates8311892nid_ates
oleates7417832oleates
redates83423872redates
sedates83418042sedates
videttes1266332videttes
abates85825033_abates
ablates92416903ablates
acetates102013063acetates
adages8412953ad_ages
addaxes1634573addaxes
adepter1036113adepter
adeptest1145453adeptest
adepts9117103adept_s
adnate72913483adnate_
adulates9311913adulates
aerates74627493aerates
agates76121343_agates
agemates111110023agemates
agnates82813193agnates
airdates939723airdates
alates64833963_alates
annates72415423annates
aretes64425353are_tes
ates45047923___ates
aviates10313063aviates
bates75846343__bates
beaten84617063_beaten
beater84729393_beater
beaters94925043_beaters
beats76042243_beat_s
bedmates1349183bedmates
berates94126873berates
bidets95215533bide_t_s
bleated104015973bleated
bleater94515303bleater
bleaters103412323bleaters
bleats85518613bleat_s
borates94823013borates
breathes134212903breathes
breaths124411183breaths
carates95630613carates
caseates10313713caseates
cates75951893__cates
ceases84427073_ceases
cerates95428253cerates
certes84623083_certes
cetes75731103_ce_tes
cheated134416343cheated
cheater124816963cheater
cheaters133613513cheaters
cheats114519543cheat_s
chelates132713843chelates
ciliates10413453ciliates
cineastes1165563cineastes
citrates102315093citrates
cleated103417843cleated
cleats84919313cleat_s
cleaves124111623cleaves
comates114123643comates
crates85736063_crates
creases94020963creases
create85126383create_
created104323453created
cremates124216003cremates
curates95323833curates
daces85030683_d_aces
dales66439743_d_ales
dames85435853_d_ames
dares66146703_d_ares
date56443323_d_ate_
dated75530993_d_ated
dater65332313_d_ater
daters74827373_d_aters
datos65222783_d_atos
dazes155024143_d_azes
deaden83714323_deaden
deadens93410693_deadens
deader84220473_deader
deadest93014883_deadest
deads75726913_dea_ds
deafen10389673_deafen
deafens11317253_deafens
deafer104114813_deafer
deafest112911513_deafest
deairs74013783_deairs
dealates92716683_dealates
dealer74122143_dealer
dealers84118613_dealers
deals65435343_dea_ls
deaned84620453_deaned
deans66131393_dea_ns
dearer74822803_dearer
dearest83618673_dearest
dearies83526273_dearies
dears65736883_dea_rs
dearths11498843_dearths
deashes113313903_deashes
death94822523_deat_h
deathy134210233_deathy
deave95022333_deave_
deaved114916553_deaved
debases103814133_debases
debate94419193_debate_
debated113916083_debated
debater104114693_debater
debaters113511923_debaters
debts86418373_debt_s
debyes1238103_debyes
decades113615513_decades
decanes103118913_decanes
decares102818533_decares
dees56356633_de__es
deets65330243_deet_s
defaces133213403_defaces
defames132812253_defames
defats105114553_defat_s
defies104624053_defies
deflates123013943_deflates
defter104215923_defter
deftest112611713_deftest
degames113312623_degames
degases93413103_degases
deices94119373_deices
deities82621923_deities
dekares122710873_dekares
dekes105224453_de_kes
delate73827753_delate_
delated93722873_delated
deles65139253_de_les
deletes83117933_deletes
deltas74414823_deltas
delts65731793_delt_s
delves104917083_delves
demes86032693_de_mes
demies94825803_demies
demotes104717673_demotes
denes65639723_de_nes
denies74729643_denies
denotes83817003_denotes
dented84120513_dented
dents65031803_dent_s
depths12428573_depths
deputes104911783_deputes
derate74531233_derate_
derated93623503_derated
derats74625063_derat_s
deter65028043_de_ter
deters74724683_de_ters
detest74122843_de_test
deuces94015513_deuces
deviates12312733_deviates
devotes113713753_devotes
dewater112912423_dewater
dewaters122910723_dewaters
dewaxes18297843_dewaxes
dexes135224513_de_xes
dexies145018343_dexies
dexter143810893_dexter
dictates11311383dictates
dienes75719903die_nes
dieses75218693die_ses
diester83013683diester
diesters92513603diesters
dieted83115493die_ted
dieter73516773die_ter
dieters83216433die_ters
diets66026643die_t_s
dilate73220693dilate_
dilated93115823dilated
dilater83515653dilater
dilaters92513063dilaters
dilutes82911973dilutes
dinettes9310193dinettes
diseases92415813diseases
disrates91118153disrates
dites66339153_d_ites
doated84118183_doated
doats65224883_doat_s
donates83217223donates
dotes65836693_d_otes
drakes114715863_drakes
drapes95419653_drapes
drats66628373_drat_s
eases56041613__eases
eaten55323053__eaten
eater54639843__eater
eaters65535953__eaters
eats47054873__eat_s
eaves85231993__eaves
edentates1046953edentates
educates1139623educates
elates65032363_elates
elevates111110423elevates
eluates72014683eluates
emeutes938013emeutes
enates64026433_enates
equates162012323equates
ergates8314493ergates
estates74520183estates
fates85139233__fates
feases95422923_feases
feater95224053_feater
featest102715113_featest
feats86432753_feat_s
feazes184514173_feazes
federates13310153federates
fetes85630143_fe_tes
figeater1236953figeater
figeaters1345753figeaters
filiates11412663filiates
fixates1737393fixates
folates103218453folates
gates65939513__gates
gelates83219583gelates
gentes75324163_gentes
gestes75721393_gestes
grates75429893_grates
greases84816713greases
greaten83610643greaten
greatens9307593greatens
greater84416493greater
greatest939863greatest
greats76318393great_s
greaves113311443greaves
gyrates113610263gyrates
hamates122917683hamates
hates86742573__hates
heated104525593_heated
heater94828303_heater
heaters104225223_heaters
heaths126316383_heaths
heats85838403_heat_s
heaves124120303_heaves
humates122813193humates
hydrates15229413hydrates
ibexes15436163ibe_xes
idea59122773idea___
ideal65716393idea__l
idealise938053idealise
idealises1047783idealises
idealism1147013idealism
idealist9310653idealist
idealities1148783idealities
idealizes1947393idealizes
idealless1042953idealless
ideally1137793ideally
ideating10311703ideating
ideation9310493ideation
ideations1039903ideations
ideative1238573ideative
identic1038043identic
ides57734233id___es
idiots768643idiot_s
idles66720123id__les
idlesses936003idlesses
idolater936863idolater
idolaters1045713idolaters
ignites81310583ignites
ikats95311153i_kat_s
ileitis738063ileitis
ileuses738673ileuses
ilexes134510253ile_xes
illites72415013illites
images91411463i_mages
imamates1237663imamates
imitates10310503imitates
impales113311763impales
impastes12238193impastes
imputes1138083imputes
inanes62519803i_nanes
incages103013883incages
incases93615973incases
incites93218483incites
indagates1146573indagates
indebted12246873indebted
indenes82916253inde_nes
indented101811733indented
indenter92311443indenter
indenters102710033indenters
indents83114663indent_s
indexes15339453inde_xes
indicates12312583indicates
indites83618983indites
indurates10310693indurates
inearths1144933inearths
inerts64517023inert_s
infantes11249633infantes
infares10313023infares
inflates11512193inflates
ingate73018243ingate_
ingrates9514173ingrates
inhales10511863inhales
inlaces92512903inlaces
inmate82917363inmate_
innages82911303innages
innate63917313innate_
instates81615833instates
intakes11310943intakes
invades11118293invades
invites103915813invites
inweaves1445043inweaves
iodate7313503iodate_
iodated9310023iodated
iodinates1048203iodinates
iolites73819483iolites
irades74517393i_rades
irate55627983i_rate_
irater65218353i_rater
iratest7312483i_ratest
isolates8613513isolates
iterate71119113iterate_
iterated91213823iterated
jadeites1645823jadeites
jetes124922843_je_tes
karates115617473karates
kentes105118653_kentes
leases65428113_leases
leaves94222383_leaves
legates82917683legates
liberates111012943liberates
librates103412953librates
ligates82318383ligates
limeades11116643limeades
lineages979183lineages
lineate7815153lineate_
lineated9711063lineated
liquates1737453liquates
literates91415653literates
locates93218813locates
luxates1436973luxates
lysates10317473lysates
malates93522603malates
maleates103316343maleates
mates75251363__mates
meated94222403_meated
meats75034053_meat_s
meatus85112923_meatus
mediates112814063mediates
metates92720013metates
metes74736213_me_tes
migrates111112853migrates
mileages11249693mileages
misdates111113633misdates
miseases102614343miseases
miseaten10310773miseaten
miseats92815783miseat_s
mismates121114563mismates
misrates101318243misrates
moderates12710753moderates
mutates92215793mutates
nates55238333__nates
neaten64214543_neaten
neatens73310403_neatens
neater64424313_neater
neatest72516003_neatest
neats55931903_neat_s
negates83215843negates
nictates1039593nictates
nidate7313783nid_ate_
nidated939863nid_ated
niobates1037283niobates
nitrates82516223nitrates
notates72817483notates
nutates73214973nutates
oblates91913243oblates
odonates947743odonates
oleate6318883oleate_
operates10515413operates
opiates9312143opiates
orates64328613_orates
oxidates1636333oxid_ates
palates93624933palates
pates76047893__pates
peaces106324083_peaces
peages94321853_peages
peases85229473_peases
peats76140193_peat_s
pedate93117763pedate_
penates93321603penates
phenates13611583phenates
picrates122013213picrates
pileate93815923pileate_
pileated112711133pileated
pipeages1336423pipeages
pipettes1237563pipettes
pirates93020333pirates
plates85432243_plates
pleases94515483pleases
pleated103816633pleated
pleater93916333pleater
pleaters103613793pleaters
pleats85218593pleat_s
prates84633163_prates
predates11615813predates
prelates10418573prelates
pupates113311433pupates
radiates92415293radiates
rates55352013__rates
reales64934123_reales
reatas64021013_reatas
reaves94127573_reaves
rebates95123183rebates
redate74124683redate_
redated93120923redated
relates73731433relates
remates93827113remates
rentes65431193_rentes
rotates72819773rotates
sates54949323__sates
savates10312953savates
seated75131063_seated
seater64534163_seater
seaters74028943_seaters
seats54844343_seat_s
sedate73019813sedate_
sedated93714353sedated
sedater83713633sedater
sedatest9249393sedatest
senates73322613senates
sheathes14610193sheathes
sheaths1358753sheaths
sheaves134412973sheaves
sidearms1144093sidearms
siderites10410433siderites
sidestep1144243sidestep
sidesteps1243623sidesteps
sinuates8310963sinuates
situates8310373situates
skates104219403_skates
skeanes113610713skeanes
slates64934063_slates
sleaves103813203sleaves
sleazes162810333sleazes
solates73523853solates
spates85028173_spates
states64337083_states
sweated113411543sweated
sweater103712723sweater
sweaters113811063sweaters
sweats94814613sweat_s
tates55444983__tates
teases65426273_teases
teated74924023_teated
teats55636813_teat_s
testes65125823_testes
theater104014253theater
theaters114211903theaters
theatres11298633theatres
tidewater1344123tidewater
tidewaters1443463tidewaters
titrates82314663titrates
treated83618703treated
treater74219833treater
treaters83615843treaters
treaties8316983treaties
treats64821693treat_s
uneases73316263uneases
uneaten7412543uneaten
updates10329793updates
uprates93814863uprates
urates65027763_urates
ureases74416723ureases
vacates12312833vacates
vedettes1265943vedettes
vibrates132210613vibrates
videotex1942673videotex
vidette1167543vidette_
violates11311193violates
virgates1237923virgates
vitiates112311433vitiates
weaves123616373_weaves
wheaten1336403wheaten
wheatens1454663wheatens
wheats125013223wheat_s
wreathes14299893wreathes
wreaths13338373wreaths
yentes95517603_yentes
zincates1937743zincates

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274966.31321230.3
3Display Results4964960.1862666.7
 (SQL Overall)1786914966.90525878.5
 
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.