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

317 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
idioms95641(None) 
idiom899951idiom_
idiots768641idiots
adios65822862adio_s
axioms15408052axioms
dims75435022_di_ms
diols65521012_diols
doms76239572_d_oms
dooms85321342_dooms
idiocy1273462idiocy
idiot6718852idio_t
idols65514132id_ols
indiums1037142indiums
inions64417002inions
iodisms10308482iodisms
odious749932odious
odiums9337942odiums
adeems946333adeems
adieus739633adieus
adipous1037183adipous
adits66523713adi_ts
ados57633513ad_o_s
agios65919863agio_s
agisms9399393agisms
aims67738183_ai_ms
anions64123033anions
atoms76817563_atoms
audios72312283audio_s
avions94114393avions
axiom143913593axiom_
axions134713483axions
bedims1149593bedi_ms
besoms105712733besoms
bidis86721143bidi__s
bilious9310933bilious
biogs85016113_biogs
biome94916993_biome
biomes103815253_biomes
bios66335313_bio_s
blooms104613173blooms
booms95427123_booms
bosoms104913043bosoms
brims94721623bri_ms
brios74725723brio_s
brooms104915873brooms
caroms105619573caroms
celoms10412123celoms
chirms135113983chirms
cions75222853_cions
civisms1436073civisms
dams77444373_d_ams
deems85421773_deems
deisms94411043deisms
demos86022993_demos
derms85022893_derms
dhows125911223_dhows
dials64925343_dials
diatoms1039073diatoms
dibs76233673_di_bs
dices86434243_dices
dicks125824693_dicks
dicots94915793dicots
didies84621833didi_es
didoes85716963didoes
didos76820813_didos
dies55653523_di_es
diets66026643_diets
diffs126315483_diffs
difs86027323_di_fs
digs66036053_di_gs
dikes105831333_dikes
dills65530973_dills
dim68146493_di_m_
dime76237643_di_me
dimes85833043_dimes
dines66449153_dines
dings76331403_dings
dinks105927953_dinks
dinos65428063_dinos
dins56652043_di_ns
dints67431313_dints
diode74716113_diode
diodes83915783_diodes
diol57329133_dio_l
dips75536913_di_ps
dirams94413703dirams
dirks105619523_dirks
dirls64720503_dirls
dirts66824463_dirts
dis46459893_di__s
discs85316263_discs
disks105417473_disks
disme85716243_disme
dismes95617673_dismes
diss56434483_di_ss
ditas65923673_ditas
dites66339153_dites
dits56450523_di_ts
divas95418583_divas
dives95832403_dives
divots104712203divots
docs75631153_d_ocs
does56554473_d_oes
dogs66440153_d_ogs
doits66223673_doits
dols56943053_d_ols
dom69752443_d_om_
dome77240733_d_ome
domes85735563_d_omes
dons56048703_d_ons
doom76430073_doom_
doomy116018263_doomy
doors65022133_doors
dorms85723833_dorms
dors56747603_d_ors
dos48062313_d_o_s
doss56235043_d_oss
dots55647663_d_ots
doums85417643_doums
dows85941053_d_ows
drams86025833_drams
drops85719503_drops
dross65418093_dross
drums85415873_drums
duomi8310133_duomi
duomo839753_duomo
duomos936823_duomos
duos56728133_duo_s
eddoes8199143eddoes
edicts94911703edicts
ediles74016973ediles
editors839423editors
edits65819033edi_ts
eidos65817753eid_o_s
fideisms1444453fideisms
fidos95819053fid_o_s
films105617963_films
firms105217423_firms
genoms94412483genoms
glims87417673gli_ms
glioma935953glioma
gliomas1035333gliomas
gloms85219783_gloms
glooms96211683glooms
griots74713643griots
grooms94512523grooms
hideous1168433hideous
hidings12349693hidings
hims95230973_hi_ms
ibices10398153ibices
ibis66519563ibi__s
ibises83610533ibises
ichors11310413ichors
icings9428453icings
icons76516493i_cons
ideals75012503ideals
ideas65919013id_eas
idem76121063id_em_
ides57734233id__es
idiocies1145223idiocies
idiotic1037453idiotic
idiotism1144553idiotism
idiotisms1244203idiotisms
idlers74012813idlers
idles66720123id_les
idol56818633id_o_l
idolisms1146353idolisms
ids47535463id___s
idylls10425253idylls
idyls9498803id_yls
igloos738033igloos
ihrams1137173ihrams
ikons96311013i_kons
iliads7448673iliads
ilium74614173ilium_
imams91511103i_mams
imaums10106293imaums
imides94515333imides
imids86015123imi_ds
imines84918343imines
impious1137053impious
inarms8410093inarms
incogs937903incogs
income10712093income
incomes11712373incomes
indices103513443indices
indicts103210723indicts
indies73822773indi_es
indigoes10276783indigoes
indigos9347823indigos
indites83618983indites
indium939493indium_
indols74714203indols
indoors838553indoors
indows104210793indows
infirms1245563infirms
informs1248063informs
infos84311673info_s
ingots7912063ingots
inion54620173inio_n
intomb1036403intomb
intombs1144153intombs
iodides93811613iodides
iodids83711143iodi_ds
iodines83616633iodines
iodins74216513iodi_ns
iodises83413633iodises
iodism93611123iodism_
iodizes173911723iodizes
iodous7311493iodous
ioniums938303ioniums
ions46737853__ions
irides74519123irides
iridiums1144523iridiums
irids66417763iri_ds
iris45732543iri__s
irises64221173irises
iritis63113733iritis
irons55324133i_rons
isms66213473__isms
items7499613i_tems
ivies84215753ivi_es
iwis77117003iwi__s
ixias12488363ixi_as
jisms14458003_jisms
kiddoes13387063kiddoes
kiddos12416863kiddo_s
kilims1277903kili_ms
lidos65219883lid_o_s
limos75320813_limos
lions55923213_lions
looms75124643_looms
madtoms1236923madtoms
maims96321783mai_ms
mediums12308723mediums
midirons1145883midirons
midis85923403midi__s
minims104514803mini_ms
minions93314623minions
miniums113910213miniums
moms86539483__moms
nimious937663nimious
nims66226883_ni_ms
noms65636403__noms
nudisms10305853nudisms
odeons739023odeons
odeums9367313odeums
odists749853odists
odium83413033odium_
odors64514273od_ors
oidioid946043oidioid
oidium959813oidium_
olios54520853olio_s
oms56337513___oms
onions64016433onions
opiums10307073opiums
oxims14107643oxi_ms
pinions93413603pinions
pions75826393_pions
pious74621273_pious
podiums12227633podiums
poms87037743__poms
primos104514423primos
prims95425933pri_ms
prions84317783prions
priors83914483priors
prisms104915503prisms
proms95426403_proms
radios74018673radio_s
radiums10299303radiums
ridings93412083ridings
rims65936303_ri_ms
riots54922013_riots
roms67038963__roms
rooms75324683_rooms
sadisms10359113sadisms
scions82612233scions
seisms84912143seisms
shims104422543shi_ms
sidings94011453sidings
simious939803simious
simooms1135573simooms
sims65737173_si_ms
sitcoms1145533sitcoms
skimos12548803skimos
skims114517183ski_ms
slims75423653sli_ms
sodiums10177213sodiums
sodoms989663sodoms
soms66239373__soms
swims105514143swi_ms
tedious838443tedious
tediums10266973tediums
thiols95112763thiols
tidiers8389773tidiers
tidies74721833tidi_es
tidings93810253tidings
toms68343493__toms
trims75021473tri_ms
triols66117803triols
trios55528093trio_s
udons65411463ud_ons
udos56619903ud_o_s
unions64216753unions
venoms114211213venoms
vicious1239493vicious
videos104911373video_s
vidicons1443863vidicons
vims95423313_vi_ms
viols86118103_viols
virions1039873virions
visions10311023visions
vrooms11398713vrooms
whims134515333whi_ms
widows1376563wid_ows
wisdoms1335453wisdoms
zooms164415523_zooms

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127163176.10618459.9
3Display Results3173170.2031561.6
 (SQL Overall)1786913176.45227695.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.