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

449 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
ideating1031170(None) 
beating104326872_beating
bleating113514502bleating
cheating144014522cheating
cleating113518142cleating
creating113921952creating
dating85326482_d_ating
dealing94323232_dealing
deaning94020472_deaning
deaving123814752_deaving
debating123213732_debating
delating103119602_delating
denting94422182_denting
derating103222282_derating
dieting93616832die_ting
dilating102714912dilating
doating93816862_doating
eating75134402__eating
heating114024322_heating
ideation9310492ideation
ideations1039902ideations
ideative1238572ideative
indenting11911262indenting
iodating1038822iodating
iterating10314252iterating
miseating121215432miseating
nidating1039782nid_ating
pleating112916052pleating
redating102620172redating
seating84130682_seating
sedating103014112sedating
sweating123213022sweating
treating92519612treating
abating10413973_abating
abetting1158293abetting
ablating11312003ablating
adapting1236643adapting
adeeming1254793adeeming
adopting1237453adopting
adulating1178723adulating
advecting1645113advecting
adverting1437223adverting
aerating92821003aerating
agenting1039383agenting
alerting91312383alerting
anearing9413973anearing
averting122512733averting
aviating12311023aviating
bating95132253__bating
beading113221863_beading
beaming123618803_beaming
beaning103820683_beaning
bearing103624773_bearing
beatings114113233_beatings
belting104119133_belting
berating113220763berating
besting104923923_besting
betting103921403_betting
bisecting1436973bisecting
blearing113111943blearing
bloating113512813bloating
boating103721303_boating
borating113414503borating
breading123515463breading
breaking153914253breaking
breaming133612513breaming
breasting1239583breasting
breathing15218373breathing
caseating12311743caseating
caveating1539293caveating
ceasing104118263_ceasing
chelating1549363chelating
cleaning113112383cleaning
clearing113014883clearing
cleaving141389683cleaving
clefting14347583clefting
coating103525313_coating
crating103725203_crating
creaking153414123creaking
creaming133413143creaming
creasing113314443creasing
creatin93618133creatin_
creatine103417413creatine
creatins103617513creatins
cremating14312203cremating
cresting114017043cresting
curating11314293curating
daring84928683_d_aring
darting94020663_darting
dauting93814763_dauting
dawing114819823_d_awing
dawting123610673_dawting
dazing175516513_d_azing
deairing10311893_deairing
dealings103510703_dealings
deashing134210953_deashing
debasing12238063_debasing
debiting122511203_debiting
debuting12268633_debuting
decanting132510633_decanting
decaying15239453_decaying
decking153915593_decking
deeding103315123_deeding
deeming113913123_deeming
defacing15238683_defacing
defaming15238463_defaming
defatting1436103_defatting
defeating142311973defeating
deflating142610713_deflating
defying15328823_defying
deicing11312193_deicing
dekeing13358353_dekeing
deking125614553_de_king
delaying133210973_delaying
deleing93313953_deleing
deleting103314423_deleting
delving123711573_delving
demasting1338453_demasting
demoing11311753_demoing
demoting12311423_demoting
denning93515173_denning
denoting10311753_denoting
dentin73919573_dentin_
dentine83320243_dentine
dentins83419223_dentins
denying123711293_denying
departing1349513_departing
deputing12238793_deputing
deratting1139513_deratting
desalting1138843_desalting
destine83719953_destine
destiny113111463_destiny
detain74617383_detain_
detains83716093_detains
deucing1139393_deucing
deviating14311083_deviating
devoting1338823_devoting
dewaxing20215293_dewaxing
dewing114115703_de_wing
dialing94318173_dialing
dictating1338883dictating
dieing84018653die__ing
digesting12208673digesting
dighting142510843dighting
diluting10248983diluting
dinting93520553_dinting
directing1338823directing
diseasing11310833diseasing
disrating11714553disrating
disseating121111783disseating
diverting142410333diverting
divesting14298483divesting
donating10311803donating
doting84821913_d_oting
dotting93314483_dotting
drafting13339413_drafting
draping114213353_draping
dratting10389663_dratting
drawing123812053_drawing
draying123813843_draying
dreading113712803dreading
dreaming124011063dreaming
ducting113713593_ducting
dueting93814393_dueting
duetting1047183duetting
dunting93418383_dunting
dusting93618993_dusting
earing75235483__earing
easing74926463__easing
easting84924303__easting
eatings84616443__eatings
editing9313133ed_iting
educating1337933educating
egesting1039013egesting
ejecting18268163ejecting
elating83423083_elating
electing112113783electing
elevating1338203elevating
endearing1139323endearing
equating18310113equating
erecting112415063erecting
estating92614993estating
everting122213133everting
exerting162211153exerting
fating105328673__fating
fearing113520033_fearing
feasing113916653_feasing
feasting122011323_feasting
feazing205411443_feazing
federating1548853federating
felting113515213_felting
feting104417793_fe_ting
fetting113517873_fetting
fidgeting1544523fidgeting
fileting1239303file_ting
filiating1339253filiating
fixating1936183fixating
fleeting122910323fleeting
floating123111883floating
freaking163611453freaking
fretting122711523fretting
gating84826953__gating
gearing92818843_gearing
gelating103015733gelating
getting93316563_getting
gleaming12277933gleaming
gleaning10269323gleaning
gleeting10279173gleeting
gloating102611463gloating
grating93923183_grating
greasing102811393greasing
greeting103112353greeting
guesting1058463guesting
gyrating1337453gyrating
hating104929713__hating
heading122919113_heading
healing113922963_healing
heaping133015853_heaping
hearing113324163_hearing
hearting12513123_hearting
heaving144114763_heaving
hefting144510913_hefting
henting113719653_henting
hydrating1746323hydrating
iceboating1543353iceboating
idealise938053idealise
idealising1245703idealising
idealism1147013idealism
idealist9310653idealist
ideality1247153ideality
idealize1847873idealize
idealizing2147293idealizing
ideate7313683ideat__e
ideated9310973ideat_ed
ideates8313733ideat_es
ideational1146503ideational
identic1038043identi_c
identify1544133identify
identity1245373identity
idling8912883id__ling
igniting1037363igniting
imaging1138083i_maging
imitating1238763imitating
impacting1635943impacting
impaling1338253impaling
imparting1437243imparting
impasting1436323impasting
imputing1336853imputing
incaging1288673incaging
incanting1289903incanting
incasing11610603incasing
incenting12912063incenting
incepting1489293incepting
inciting11312533inciting
indagating1345263indagating
indexing1737123inde_xing
indicating1449693indicating
indicting1339613indicting
inditing10312113inditing
inducting1338373inducting
indurating1249243indurating
inearthing1443543inearthing
infecting15109673infecting
infesting13109513infesting
inflating13310443inflating
ingesting11129623ingesting
ingoting1039863ingoting
inhaling1239523inhaling
injecting1997693injecting
inlacing1158373inlacing
inlaying1247893inlaying
inletting1087873inletting
inserting10914243inserting
insetting1079283insetting
instating10812213instating
intreating11614013intreating
invading1336263invading
inventing13109973inventing
inverting131013223inverting
investing13119393investing
inviting1239733inviting
inweaving1644773inweaving
iodinating1246963iodinating
isatin6412213i_satin_
isatine7311763i_satine
isatins7310773i_satins
isolating1039743isolating
iteming1037753ite_ming
jesting154317713_jesting
jetting153815343_jetting
kidnaping1742353kidnaping
kneading1436373kneading
leading93419553_leading
leafing113313583_leafing
leaking123616973_leaking
leaning83721203_leaning
leaping103215993_leaping
leasing83920163_leasing
leaving114216853_leaving
legating102313113legating
letting83218533_letting
liberating1349253liberating
librating1239053librating
ligating102212283ligating
liquating1946313liquating
locating11311503locating
luxating1645613luxating
mating94832913__mating
meaning103918703_meaning
medaling121912263medaling
mediating13311203mediating
meeting103314963_meeting
melting103317753_melting
meting94320593_me_ting
migrating13910533migrating
misdating131010663misdating
misdealing1457363misdealing
mismating141211823mismating
misrating121014853misrating
misseating131310943misseating
moating104218153_moating
moderating1448803moderating
mutating112211753mutating
nearing83020333_nearing
negating102012833negating
nesting84320443_nesting
netting84018763_netting
nictating1237573nictating
nidering10510483nide_ring
nitrating10312673nitrating
notating92513343notating
nutating92411953nutating
operating12313723operating
opiating11410093opiating
orating83520323_orating
outeating10814493outeating
oxidating1845053oxid_ating
peacing124117073_peacing
peaking144317693_peaking
pealing104123203_pealing
pedaling122412133pedaling
pelting102917273_pelting
petting103720953_petting
pipetting1435513pipetting
pirating11314513pirating
plating103823073_plating
pleading123011443pleading
pleasing112611593pleasing
prating103424453_prating
preacting142412533preacting
predating13514653predating
pupating1337683pupating
questing1838273questing
radiating111112133radiating
rating74938703__rating
reacting113317893_reacting
reading93327213_reading
reaming103924013_reaming
reaping103621213_reaping
rearing83128783_rearing
reaving113820533_reaving
rebating112418343rebating
redacting13612303redacting
reesting93118273reesting
reheating132314913reheating
relating92725443relating
remating112322423remating
renting84026853_renting
repeating122618983repeating
reseating102421533reseating
resting85031183_resting
retting83425883_retting
riveting12139443rive_ting
rivetting13256413rivetting
rotating92614553rotating
sating74735453__sating
scenting113212813scenting
sealing83528563_sealing
seaming103222113_seaming
searing83330923_searing
seatings93614303_seatings
setting83621393_setting
sheafing15329483sheafing
shealing123415463shealing
shearing123915903shearing
sheathing1636873sheathing
sheaving154110253sheaving
sheeting122712833sheeting
sideling101012183side_ling
sinuating1039683sinuating
situating1038883situating
skating123613853_skating
slating83724653_slating
sleaving123310983sleaving
sleeting93114163sleeting
smearing113511753smearing
smelting11339713smelting
sneaking133211093sneaking
sneaping11349493sneaping
solating9315593solating
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
stating83725163_stating
steading103613593steading
stealing93416603stealing
steaming114013213steaming
stetting93410713stetting
swearing123711443swearing
sweeting123911313sweeting
teaming103917593_teaming
tearing84021493_tearing
teasing83918513_teasing
tenting84621153_tenting
testing86021053_testing
threating131010053threating
titrating10310113titrating
treading103515333treading
tweaking1635883tweaking
tweeting12267033tweeting
unseating10713203unseating
updating1236593updating
uprating11311113uprating
vacating14310363vacating
vealing114217423_vealing
venting114218093_venting
vesting114618683_vesting
vetting114216563_vetting
vibrating1537483vibrating
violating1337443violating
vitiating1338413vitiating
weaning114117193_weaning
wearing113318863_wearing
weaving143211623_weaving
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wetting114117383_wetting
whetting1535973whetting
widening13237833wide_ning
wreaking163010213wreaking
wreathing16266313wreathing
wresting123811833wresting
yealing112716383_yealing
yeaning113814633_yeaning
yeasting12188923_yeasting
zeatin15412823_zeatin_
zeatins16311733_zeatins
zesting174515333_zesting

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.436409841.7
2DLD Change Limit1461624497.78318779.6
3Display Results4494490.1862414.0
 (SQL Overall)1786914498.40521260.1
 
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.