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 “lambs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

190 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
lambs9592141(None) 
gambs105721121gambs
iambs95815061iambs
jambs166014621jambs
labs67145121la_bs
lamas75532791lamas
lamb86832141lamb_
lamby125114841lamby
lames75445541lames
lamps95624831lamps
lams66552261lam_s
limbs96118941limbs
abs59356072_a_bs
alamos8415002alamos
albs68628572_albs
almas76629772almas
almes75126542almes
alms65834922alm_s
amas67746292_amas
ambo88225142_ambo
ambos95321252_ambos
amis66445322_amis
amps86230342_amps
amus65529612_amus
arbs66834732_arbs
bams87044452bam_s
barbs95928192barbs
blabs95619632bla_bs
blames105121862blames
blams95023852blam_s
bombs115818822bombs
cabs86739422ca_bs
camas96333522camas
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282cam_s
carbs96031462carbs
clamps124515082clamps
clams95127672clam_s
climbs12498722climbs
combs116122962combs
dabs77139402da_bs
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
darbs85323262darbs
daubs85014562daubs
dumbs105915752dumbs
fabs98635862fa_bs
fames105735922fames
flabs105818642fla_bs
flambe13489152flambe
flambes14419502flambes
flames114723692flames
flams105125012flam_s
gabs76740422ga_bs
gamas85431362gamas
gamb96331842gamb_
gamba106018512gamba
gambas115817512gambas
gambe106219212gambe
gambes116318312gambes
games86238552games
gamps105323712gamps
gams76648882gam_s
garbs86321412garbs
glams85822932glam_s
hames106138702hames
hams96446132ham_s
iamb86623732iamb_
iambi95512222iambi
iambus10468902iambus
jabs135830092ja_bs
jamb155523852jamb_
jambe165314752jambe
jambes175914052jambes
jams135231072jam_s
kabs107130842ka_bs
kames115024692kames
lab58864782la_b_
laces76141762laces
lacks116129202lacks
lacs66942482la_cs
lades65141272lades
lads56549132la_ds
lags56546222la_gs
laics76419252laics
lairs55425872lairs
lakes95737652lakes
lakhs125210342lakhs
lalls55324132lalls
lam57666712lam__
lama66635292lam_a
lambast11129892lambast
lambda1146112lambda
lambdas1246242lambdas
lambed115614782lambed
lamber104418492lamber
lambers113817112lambers
lambie103213672lambie
lambies113015112lambies
lame66849292lam_e
lamed85235292lamed
lameds94812032lameds
lamer75233702lamer
lamest84722762lamest
lamia75324322lamia
lamias85020612lamias
lamp86233822lam_p
lampas106615952lampas
lands65426902lands
lanes54946792lanes
lapis76223152lapis
laps66848872la_ps
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572la_rs
las37281472la__s
lases54944762lases
lass47444542la_ss
lasts57731262lasts
laths86022402laths
lats45962702la_ts
lauds65618482lauds
lavas85422222lavas
laves86039152laves
lavs76734152la_vs
lawns85215422lawns
laws76441682la_ws
laxes125430092laxes
lays76043252la_ys
lazes145129572lazes
libs66732762l_ibs
limas75627632limas
limb85429382limb_
limba95414982limba
limbas105313202limbas
limbi96513812limbi
limbo95614812limbo
limbos104712142limbos
limbus105710382limbus
limby125714072limby
limes75636502limes
limns75718392limns
limos75320812limos
limps95522672limps
llamas888972llamas
loams75619862loam_s
lobs66441082l_obs
lumas75622912lumas
lumps95624982lumps
lums65734242lum_s
mamas95930772mamas
mamba116317522mamba
mambas125716242mambas
mambo115215742mambo
mambos125414492mambos
nabs66236192na_bs
names74833362names
numbs94913092numbs
pams85641762pam_s
plumbs12459332plumbs
ramps96224632ramps
rams65950772ram_s
ramus76418282ramus
sabs66643742sa_bs
samba95618772samba
sambas104219262sambas
sambo95118012sambo
sambos104315192sambos
samps96124672samps
slabs75322642sla_bs
slams74927902slam_s
tabs66842982ta_bs
tames75242012tames
tamis76728732tamis
tamps95524082tamps
tams67247932tam_s
tombs97818732tombs
ulamas8910452ulamas
vamps125415482vamps
wabs97337232wa_bs
wames106432802wames
wamus105514682wamus
wombs125813342wombs
yams95330732yam_s

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001901.44037361.1
3Display Results1901900.0434418.6
 (SQL Overall)1786911901.779100444.6
 
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.