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

256 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
iodised932924(None) 
iodise74214941iodise_
iodises83413631iodises
iodized18969161iodized
ionised82911491ionised
bodied103814582bodi_ed
hoised105117432ho_ised
idolised1045672idolised
incised102911582incised
indited93515022indited
iodated9310022iodated
iodid74315532iodi__d
iodide84812932iodide_
iodides93811612iodides
iodine74618652iodine_
iodines83616632iodines
iodism93611132iodis_m
iodisms10308482iodisms
iodize164112592iodize_
iodizer17408662iodizer
iodizes173911722iodizes
ionise63516942ionise_
ionises72916432ionises
ionized172611292ionized
irised73913152i_rised
lionised946602lionised
noised75416232no_ised
poised94918472po_ised
advised12136043advised
agonised10248483agonised
anodized1946463anodized
atomised11278833atomised
audited939033audited
axised14438963_axised
azotised1844443azotised
biopsied1344593biopsied
birdied11329433birdi_ed
boded95124963bod__ed
bodice11711423bodice_
bodices12710593bodices
bodies94524143bodi_es
boiled95020953bo_iled
bossed94816533bo_ssed
boused95322883bo_used
bowsed125715973bo_wsed
braised104014803braised
bruised10389503bruised
caddised13315893caddised
codded114515303cod_ded
coddled123410573coddled
coded95433183cod__ed
codices12512583codices
codified1537403codified
coedited1237833coedited
cognised1256313cognised
coifed124113063co_ifed
coiled95123943co_iled
coined94523603co_ined
copied114618563copi_ed
cosied94819883cosi_ed
coursed104113603coursed
cozied184112153cozi_ed
cruised103710213cruised
demised113613683demised
devised123712563devised
diced95824683__diced
died66137853__di_ed
diked115024683__diked
dined76431993__dined
disced104914653__disced
dished114318713__dished
disked125015763__disked
dissed85220183__dissed
dived106321373__dived
dodged107514693dod_ged
doiled84817293do_iled
doited85016633do_ited
dosed76626913__dosed
dossed84516633do_ssed
doused84821163do_used
dowsed115015013do_wsed
ebonised1136043ebonised
eddied9248323eddi_ed
edited83913673_edited
endited93512913endited
excised1736673excised
focused13166413focused
foiled104618403fo_iled
foined105915013fo_ined
foisted113210603fo_isted
folioed1138033folioed
giddied11257713giddi_ed
godded104811803god_ded
godsend1084043god_send
goosed86817033go_osed
guised84612173_guised
hocused13167013hocused
hoise85224773ho_ise_
hoises94823683ho_ises
hoisted113411293ho_isted
honied104818393honi_ed
horsed105321083ho_rsed
hosed95830983ho__sed
housed105624103ho_used
howdied15296843howdi_ed
ibises83610543i_bises
idled74915213i_d_led
idolise839293idolise_
idoliser945043idoliser
idolises938763idolises
idolized1946003idolized
ignited9137623ignited
imbibed1433733imbibed
imbodied1444203imbodi_ed
immixed1933573immixed
imposed123110293imposed
incased103612393incased
incise83515333incise_
incises93414893incises
incited103314623incited
incused102911173incused
indeed83913563ind_eed
indexed16347363indexed
indices103513443indices
indicted1249203indicted
indie63721473indi_e_
indies73822783indi_es
indigen9319333indigen
indite73520323indite_
inditer83514233inditer
indites83618983indites
indorsed1066123indorsed
indowed1237443indowed
induced11298933induced
indued83411653ind_ued
inedited10278993inedited
infixed18206563infixed
infused11329253infused
insisted998673insisted
invited113612463invited
iodate7313503iodate_
iodates8312903iodates
iodic84816753iodi__c
iodids83711153iodi_ds
iodin64419353iodi__n
iodinated1146943iodinated
iodins74216523iodi_ns
iodising1037563iodising
iodizers18316123iodizers
iolite63221983iolite_
iolites73819483iolites
ionize154613873ionize_
ionizer162310123ionizer
ionizes162813343ionizes
irises64221173i_rises
ironized1858203ironized
isodose845373isodose_
itemised11105163itemised
ivied94710523i_vi_ed
ixodid15215763ixodi__d
joined144613073jo_ined
joisted15379173jo_isted
jonesed1536263jonesed
liaised837113liaised
lionise7310373lionise_
lioniser845583lioniser
lionises8310313lionises
lionized1837023lionized
lodged913815713lod_ged
loided83414023lo_ided
loosed75520893lo_osed
lorises73918593lorises
loused74822913lo_used
melodised1345043melodised
modeled1139463modeled
modemed1336723modemed
modified1537273modified
modish123813543modis_h
modiste1039283modiste
modistes1138643modistes
moiled94318863mo_iled
monied94319463moni_ed
monished1438133monished
mortised1178743mortised
mossed94818893mo_ssed
motived13357763motived
moused94423303mo_used
moussed10338913moussed
nodded94012123nod_ded
noddled10358563noddled
nodose738883nodose_
noise55723733no_ise_
noises65021853no_ises
noosed75018013no_osed
nosed65524553no__sed
noticed1037863noticed
nowise9511073nowise_
odist6421913_odis_t
odists749853_odists
odored8399223_odored
oidioid946053oidioid
oiled64429473_o_iled
opined95113853_opined
oxidised1743413oxidised
ozonised1853893ozonised
peised94817683_peised
podded115012713pod_ded
podite93315353podite_
podites103014733podites
poetised1138523poetised
poise75127893po_ise_
poiser84217243po_iser
poises84226543po_ises
policed123212233policed
polished1468433polished
ponied94920703poni_ed
posed85828413po__sed
posited10511493posited
praised104214813praised
prised94322203_prised
promised133010873promised
radioed939673radioed
raised76120333_raised
remised103516843remised
revised113815483revised
rodded93713703rod_ded
rodeoed937883rodeoed
roiled74320053ro_iled
roosed75621593ro_osed
rosed65930343ro__sed
rosined84911903rosined
roused75426443ro_used
seised74218123_seised
sodded94113303sod_ded
soiled73822473so_iled
sopited104211063sopited
soused74822983so_used
sudsed83911373sud_sed
tidied83613273tidi_ed
toadied9248013toadi_ed
toddled10328823toddled
todies74223553todi_es
toiled74420323to_iled
toited74016753to_ited
tossed74215223to_ssed
toused74122013to_used
unionised1046533unionised
updived1434093updived
vised95518763__vised
voiced123910113vo_iced
voided114011133vo_ided
vomited1337253vomited
wised95123343__wised
woopsed1344733woopsed
yodeled1236863yodeled
yodled11389653yod_led

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 Filter1786911340270.500357382.0
2DLD Change Limit1340272566.57620381.2
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.16924925.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.