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

160 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
iambics1342564(None) 
iambic12468271iambic_
ambits103713412_ambits
cambrics1645242cambrics
gambias125010732gambias
gambirs12359082gambirs
gambits12399722gambits
iambi95512212iambi__
iambs95815062iamb__s
iambus10468902iamb_us
lambies113015112lambies
tambacs13219362tambacs
alembics1442963alembics
ambers104519573_ambers
ambit94223713_ambi_t
ambles105121863_ambles
ambos95321253_amb_os
ambries111614543_ambries
amebic1239113_amebic_
amias75831473_am_ias
amice96122873_am_ice
amices105018013_am_ices
amici94217393_am_ici
amicus10389993_am_icus
amids85627513_am_ids
amies76837693_am_ies
amins75534323_am_ins
amirs75924923_am_irs
amis66445323_am_i_s
amiss75823073_am_iss
amnic95516243_amnic_
amnios84912523_amnios
antics84621453_antics
asdics9439863_asdics
aspics104211563_aspics
attics84413283_attics
babies106123653ba_bies
bambini1336583bambini
bambino1336483bambino
bambinos1443873bambinos
bamboos1348753bamboos
barbies114519593barbies
basics104915123ba_sics
cabbies133115163cabbies
cabins104418923ca_bins
camails11311743camails
cambers134017433cambers
cambia124913153cambi_a
cambial134010763cambial
cambism1538033cambism
cambisms1645793cambisms
cambist13312113cambist
cambists1437023cambists
cambium1537323cambium
cambiums1644923cambiums
cambric1537363cambric_
cammies134016473cammies
comics124015563com_ics
cubics123810163_cubics
cumbias13338963cumbias
darbies104216983darbies
darics94314113da_rics
diamins10312203diam_ins
fabrics1436093fabrics
fanfics1535173fanfics
gabies93820733ga_bies
gambas115817513gamb_as
gambes116318313gamb_es
gambia115912243gambi_a
gambier124711973gambier
gambiers13337073gambiers
gambir11509763gambi_r
gambit114714203gambi_t
gambles124016203gambles
gambols1238593gambols
gambs105721123gamb__s
gamic103916193gam_ic_
gamins94420043gam_ins
garlics1038013garlics
habits113014653ha_bits
iamb86623733iamb___
iambuses1235783iambuses
iatric8312153iatric_
ibices10398163i__bices
ibis66519583i__bi_s
imbeds11456743i_mbeds
imbibe1234703i_mbibe
imbibes1334693i_mbibes
imbues1037983i_mbues
imids86015143i_m_ids
immies102412443i_mmies
impis96213853i_mpi_s
ionics84214483i_onics
irenics937833irenics
italics936993italics
jambes175914053jamb_es
jambing19328533jambing
jambs166014623jamb__s
jammies183611293jammies
kamiks11387913kam_iks
kamsins1346963kamsins
laics76419253la__ics
lambdas1246243lambdas
lambers113817103lambers
lambie103213673lambi_e
lambier113611643lambier
lambiest122410183lambiest
lambing123412413lambing
lambkins1664983lambkins
lambs95921413lamb__s
lamias85020613lam_ias
limbic12528743limbic_
magics115311613ma_gics
mambas125716243mamb_as
mamboes135011823mamboes
mambos125414493mamb_os
mamies104626243mam_ies
mammies104314763mammies
manics103919933ma_nics
mastics112614783mastics
mics87435153__m_ics
mimics1289363mim_ics
nabis76020583na_bi_s
osmics1036463osm_ics
panics103815363pa_nics
phobics16286703phobics
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabbi_s
rabbits11299863rabbits
rabic93817403ra_bic_
rabies85226023ra_bies
ramblas112710263ramblas
rambles113118313rambles
ramies84630463ram_ies
ramtils938413ramtils
sabins85521983sa_bins
sabirs85414633sa_birs
sambals115213483sambals
sambars115113843sambars
sambas104219263samb_as
sambos104315193samb_os
sambuca1344343sambuca
sambucas1444163sambucas
samburs11369343samburs
tabbies112913503tabbies
tabbis102910863tabbi_s
tactics1149323tactics
tambac122210243tambac_
tambaks15218153tambaks
tamburs11288603tamburs
tameins9311413tameins
tamis76728723tam_i_s
tammies113814683tammies
tombacs13248433tombacs
wambles143714023wambles
yabbies14279643yabbies
zamias174212923zam_ias
zombies2037993zombies
zombis1936283zombi_s

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271607.97016816.4
3Display Results1601600.0802000.0
 (SQL Overall)1786911608.20621775.7
 
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.