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

283 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
ionizer16231012(None) 
iodizer17408661iodizer
ionize154613871ionize_
ionized172611291ionized
ionizers17257711ionizers
ionizes162813341ionizes
lionizer1756051lionizer
bonier84321992boni_er
bonzer175313672bon_zer
cognizer2055862cognizer
conifer123212642conifer
deionizer1945802deionizer
idolizer1845662idolizer
igniter8147672igniter
iodize164112592iodize_
iodized18969162iodized
iodizers18316122iodizers
iodizes173911722iodizes
ionise63516942ionise_
ionised82911492ionised
ionises72916432ionises
ionomer939832ionomer
ironize16610372ironize_
ironized1858202ironized
ironizes17510372ironizes
lioniser845582lioniser
lionize1668822lionize_
lionized1837022lionized
lionizers1844242lionizers
lionizes1738772lionizes
moniker1338672moniker
ozonizer1654472ozonizer
tonier65520712toni_er
unionizer1844622unionizer
agnize16329563agnize_
agnized18247223agnized
agnizes17328843agnizes
agonize172911403agonize_
agonized19258993agonized
agonizes182610583agonizes
atomizer19298533atomizer
boiler84319273bo_iler
bonder95324783bon_der
boner75133083bon__er
boneyer1237403boneyer
bonnier94711313bonnier
bonze165119353bon_ze_
bonzes175116103bon_zes
boozer174815963bo_ozer
boozier18349013boozier
botanizer2046243botanizer
boxier154311743boxi_er
bronzer18348493bron_zer
bronzier1935633bronzier
canonizer2046693canonizer
cognize1957683cognize_
cognized2136293cognized
cognizers2164433cognizers
cognizes2058033cognizes
coiler84421593co_iler
coiner84323783co_iner
coinfer12419393coinfer
cointer93616723cointer
colonizer20309283colonizer
conciser12310243conciser
confer114018683con_fer
confider1438123confider
confiner13311193confiner
conger95024273con_ger
conies84338593coni_es
conifers133611703conifers
conine84528553conine_
conines93827793conines
conker124721553con_ker
conner84423963con_ner
conniver1337493conniver
conquer1838623conquer
consider11310393consider
copier103722893copi_er
cornier93017093corni_er
cosier84423753cosi_er
cowier113616163cowi_er
cozier173315143cozi_er
deionize1858683deionize_
deionized2057153deionized
deionizers2053973deionizers
deionizes1958213deionizes
denier74420693deni_er
denizen1737663denizen
donniker1333923donniker
donzel1636313don_zel
doozer163910463do_ozer
dopier93515923dopi_er
dotier73917033doti_er
downier11299703downi_er
dozer158419273do__zer
dozier163611633dozi_er
ebonize1838153ebonize_
ebonized2036973ebonized
ebonizes1938073ebonizes
finnier10319953finni_er
fonder104120063fon_der
fondler11348883fondler
foxier163910033foxi_er
fozier183710663fozi_er
frizer184011283_frizer
ginnier8298983ginni_er
goiter74116203go_iter
goner66025163gon__er
gooier73516213gooi_er
goonier83612843gooni_er
gorier73719373gori_er
hokier134214033hoki_er
holier94921623holi_er
homier116416993homi_er
honer85332093hon__er
honied104818393honi_ed
honker134117463hon_ker
honorer1039673honorer
hornier103012463horni_er
hosier94219613hosi_er
howitzer2341913howitzer
icier74313753i_ci_er
ickier12439923icki_er
idoliser945043idoliser
idolize1737783idolize_
idolized1946003idolized
idolizers1944143idolizers
idolizes1837553idolizes
iffier1236763iffi_er
ignite71410583ignite_
ignited9137623ignited
igniters9126233igniters
ignites81310583ignites
ignitor8125263ignitor
ignorer8276103ignorer
imbiber1333593imbiber
immunizer2243263immunizer
inaner62213543i_naner
incher114114033i_ncher
inciter93113773inciter
inditer83514233inditer
infer84215033i_n_fer
inker94421093i_n_ker
inkier104013783i_nkier
inlier63615363i_nlier
inner54920633i_n_ner
insider849733insider
inter55028493i_n_ter
inviter104112313inviter
iodide84812933iodide_
iodides93811613iodides
iodine74618653iodine_
iodines83616633iodines
iodise74214943iodise_
iodised9329243iodised
iodises83413633iodises
iolite63221983iolite_
iolites73819483iolites
ionic74622663ioni__c
ionics84214483ioni_cs
ionium8610923ioni_um
ioniums938303ioniums
ionizing1839503ionizing
ionogen837123ionogen
ionomers1038503ionomers
ionone6313443ionone_
ionones7313883ionones
ironer64216453iron__er
ironies7517423ironi_es
itemizer19104453itemizer
joinder15337593joinder
joiner134114133jo_iner
jointer14379713jointer
jokier17618753joki_er
juniper1634023juniper
knifer13598563_knifer
linier64423793lini_er
lionise7310373lionise_
lionised946603lionised
lionisers944173lionisers
lionises8310313lionises
logier75015733logi_er
loiter64619173lo_iter
loner55431043lon__er
longer75823203lon_ger
loonier73312683looni_er
lorimer937753lorimer
loriner7511893loriner
lunier64617603luni_er
miniver1238393miniver
moiler84017263mo_iler
momzer19327553mo_mzer
moneyer1237903moneyer
monger94418333mon_ger
monicker1635733monicker
monie75631653moni_e_
monied94319463moni_ed
monies83233163moni_es
monikers1437413monikers
monitor9310723monitor
monomer11311893monomer
monster93214603monster
moonier93714103mooni_er
mopier103914783mopi_er
nicer74618293__nicer
niter55028973__niter
noninert8415023noninert
nonuser7299143nonuser
nonzero1646123non_zero
nosier63716323nosi_er
noticer937273noticer
oiler54628283_o_iler
oilier64417233oili_er
onager739663_onager
oozier153610253oozi_er
osier53518013_osi_er
ozonize1546293ozonize_
ozonized1745113ozonized
ozonizers1753233ozonizers
ozonizes1636083ozonizes
panier84425503pani_er
panzer174213233pan_zer
phonier122710633phoni_er
pinier84024693pini_er
pioneer936893pion_eer
poetizer1936813poetizer
pointer93814933pointer
poiser84217243po_iser
pokier124914633poki_er
policer113112683policer
politer92417073politer
ponder94521693pon_der
ponied94920703poni_ed
ponies84833463poni_es
pornier93413133porni_er
potzer174411213po_tzer
poxier153812113poxi_er
prizer174714883_prizer
punier84519223puni_er
ropier84118803ropi_er
rosier64221263rosi_er
rotifer1036993rotifer
rozzer1437353ro_zzer
seizer154114573_seizer
simonize1947813simonize_
simonized2146523simonized
simonizes2047823simonizes
sizer145521813__sizer
snider74413913_snider
sniper84413643_sniper
snoozer16409193snoozer
solider82912453solider
sonder73623523son_der
sonsier7711743sonsier
stonier72013793stoni_er
tinier63622233tini_er
tinnier72910143tinni_er
toiler63918283to_iler
toner55336243ton__er
tonger74719683ton_ger
tonner64819203ton_ner
unionize1747063unionize_
unionized1946673unionized
unionizers1943013unionizers
unionizes1846113unionizes
uniter64619143_uniter
vinier93716743vini_er
voicer113910543vo_icer
voider103611553vo_ider
vomiter1237953vomiter
wanier93920683wani_er
winier94522453wini_er
womanizer2346243womanizer
wonder103617813won_der
wonkier1437423wonkier
wonner95114443won_ner
woozier19347323woozier
yonder103214133yon_der
yonker134110853yon_ker
zanier154314713zani_er
zoner144520343zon__er
zooier153411233zooi_er

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.403443402.0
2DLD Change Limit1340272836.28321331.7
3Display Results2832830.0933043.0
 (SQL Overall)1786912836.77926359.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.