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

227 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
iambic1246828(None) 
iambi95512221iambi_
iambics13425641iambics
ambit94223712_ambit
amebic1239112_amebic
amnic95516242_amnic
cambia124913152cambia
cambric1537382cambric
gambia115912252gambia
gambir11509772gambir
gambit114714212gambit
gamic103916202gam_ic
iamb86623732iamb__
iambs95815062iamb_s
iambus10468902iambus
iatric8312162iatric
lambie103213672lambie
limbic12528742limbic
rabic93817402ra_bic
tambac122210242tambac
acmic11312333_acmic
agamic113110563agam_ic
alembic1354773alembic
amain74922913_amain
amber94523213_amber
ambits103713413_ambits
amble95924643_amble
ambo88225143_amb_o
ambos95321253_ambos
ambry123512103_ambry
ami56646813_am_i_
amia66836903_am_ia
amice96122873_am_ice
amici94217393_am_ici
amid77036353_am_id
amidic114012873_amidic
amie66339853_am_ie
amin66042253_am_in
aminic104413513_aminic
amir65129753_am_ir
amis66445323_am_is
amnia75918643_amnia
amnio75218053_amnio
amoebic1346153_amoebic
amylic13108713_amylic
antic75728863_antic
arabic10312733arabic
areic73219393_areic
asdic83814093_asdic
aspic95114733_aspic
attic75618353_attic
aulic74420243_aulic
auric74521733_auric
azoic162912063_azoic
bambini1336583bambini
bambino1336483bambino
bamboo12310013bamboo
barbie105018353barbie
bardic11312923bardic
baric96125693ba_ric
basic96220523ba_sic
cabbie122913353cabbie
cabin94820943ca_bin
cadmic1338983cadmic
calcic9311873calcic
camail10314833camail
camber124418483camber
cambial134010763cambial
cambism1538033cambism
cambist13312113cambist
cambium1537323cambium
cambrics1645253cambrics
cammie124615293cammie
campi116217783campi_
cantic103920543cantic
capric12411803capric
caseic103212373caseic
comic114721813com_ic
cubic114313423_cubic
cumbia12379893cumbia
dammit11311133dammit
daric85623113da_ric
demic105119193dem_ic
diamin9312523diam_in
domic104317243dom_ic
emic86422753_em_ic
fabric1337833fabric
fanfic1436313fanfic
filmic13348453film_ic
gallic9411643gallic
gamb96331843gamb__
gamba106018513gamb_a
gambas115817513gambas
gambe106219213gamb_e
gambes116318313gambes
gambias125010733gambias
gambier124711973gambier
gambirs12359083gambirs
gambits12399723gambits
gamble115417183gamble
gambol1138223gambol
gambs105721123gamb_s
gametic1239993gametic
gamin84423003gam_in
garlic9310043garlic
habit103027023ha_bit
haemic133210083haemic
haptic13511893haptic
hemic125718623hem_ic
humic124113243hum_ic
ibis66519583i__bis
iconic10411593iconic
ictic9311803i_ctic
imbed105013653i_mbed
imbibe1234703i_mbibe
imbue939483i_mbue
imid76122293i_m_id
imidic11358203imidic
immix1635033i_mmix
impi85415793i_mpi_
impis96213853i_mpis
iodic84816753i_odic
ionic74622663i_onic
irenic8311103irenic
iridic9328743iridic
iritic83213823iritic
ironic8313773ironic
italic839903italic
jamb155523853jamb__
jambe165314753jamb_e
jambed184811403jambed
jambes175914053jambes
jambing19328533jambing
jambs166014623jamb_s
kami105823643kam_i_
kamik105011553kam_ik
kamsin1238323kamsin
kaonic1238763kaonic
karmic1438113karmic
labia75219013la_bia
lactic10713493lactic
laic65931563la__ic
lamb86832143lamb__
lambda1146113lambda
lambed115614783lambed
lamber104418493lamber
lambier113611643lambier
lambies113015113lambies
lambing123412413lambing
lambkin1545243lambkin
lambs95921413lamb_s
lamby125114843lamb_y
lamia75324323lam_ia
limbi96513813limbi_
limnic10418843limnic
mafic125615463ma_fic
magic105818653ma_gic
malic94525663ma_lic
mamba116317523mamb_a
mambas125716243mambas
mambo115215743mamb_o
mambos125414493mambos
mamie95826003mam_ie
mammie94313783mammie
manic94629443ma_nic
mantic104120903mantic
mastic103119173mastic
miasmic1335743miasmic
mic77647643__m_ic
mimic111414323mim_ic
nabis76020583na_bis
naric76824173na_ric
nastic82915973nastic
nimbi94910313nimbi_
niobic1037243niobic
ohmic1237833ohm_ic
osmic939913osm_ic
panic93923903pa_nic
phobic153010073phobic
pianic103714123pia_nic
plumbic1543963plumbic
pubic114513723_pubic
rabbi93113183rabbi_
rabbin103112303rabbin
rabbis102613163rabbis
rabbit102914563rabbit
rabid84520783ra_bid
rambla103510933rambla
ramble104519973ramble
rami66034093ram_i_
ramie75027823ram_ie
ramtil8311023ramtil
rhombic16264533rhombic
sabin74924953sa_bin
sabir75917003sa_bir
salic73424713sa_lic
samba95618773samb_a
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sambo95118013samb_o
sambos104315193sambos
sambuca1344343sambuca
sambur10469503sambur
sialic8313633sia_lic
sorbic10310393sorbic
tabbis102910863tabbis
tabid84418263ta_bid
tactic10612753tactic
tambacs13219363tambacs
tambak14249263tambak
tambur10358713tambur
tamein8313093tamein
tamis76728733tam_is
tammie104212693tammie
tannic82811473tannic
terbic10410963terbic
tombac12258883tombac
vatic10316423va_tic
viatic11311453via_tic
wamble134415753wamble
wambly16388663wambly
yabbie13308663yabbie
zamia165115213zam_ia
zombi1838993zombi_
zombie1937323zombie
zombis1936283zombis

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.393454684.5
2DLD Change Limit1127162275.85619248.0
3Display Results2272270.0802837.5
 (SQL Overall)1786912276.32928233.7
 
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.