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

185 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
ism5632239(None) 
is27048221is_
isms66213471isms
jism135514781jism
sim56553151sim
agism84614062agism
aim57858222aim
aims67738192aims
ais39083582ais_
am411875562_am
arm58449632arm
as211083072as_
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
bam78560142bam
bis56860672bis_
bise66437112bise
bisk106523362bisk
bum75342692bum
cam78058982cam
cis57748042cis_
cist67244972cist
cum76440162cum
cwm106815082cwm
dam67457042dam
deism84116032deism
dim68146502dim
dims75435032dims
dis46459902dis_
disc76123242disc
dish86328342dish
disk96625842disk
disme85716242disme
diss56434492diss
dom69752442dom
elm57531742elm
em49445152_em
ems56435492ems
es29048222es_
ess36030882ess
fem86040732fem
film94828182film
firm96026462firm
fisc96819762fisc
fish106926282fish
fist76248432fist
gam67060062gam
gem66840222gem
gismo848862gismo
gist56046772gist
gum67439532gum
gym95719062gym
ham86363282ham
hem86148732hem
him86247672him
hims95230982hims
his66359512his_
hisn79620942hisn
hiss75629222hiss
hist76551552hist
hm78126732_hm
hmm106218992hmm
hum85542932hum
iamb86623732iamb
ice56737252ice
ich86227752ich
ick97329332ick
icy86322132icy
id38941852i_d
idem76121072idem
ids47535482ids
if57239962i_f
iff96730402iff
ifs67124252ifs
igg57116802igg
ilk78325312ilk
ill37437102ill
imam81718332imam
immy114611832immy
imp76626982imp
in28150872i_n
ink76433642ink
inn36727442inn
ins35945612ins
ion36051032ion
ire36943182ire
irk76426372irk
isba61310882isba
isle45121702isle
it28455692i_t
item65620382item
its35538842its
ivy96317452ivy
jam126942522jam
jisms14458002jisms
kis78051492kis_
kiss85227412kiss
kist86540812kist
lam57666712lam
lis37162282lis_
lisp68926892lisp
list47055352list
lum55542932lum
mem77943472mem
miasm91211092miasm
mim76048432mim
mis58162632mis_
mise66043592mise
miso67229912miso
miss65339432miss
mist66154542mist
mm67826812_mm
mom78853162mom
mum76643612mum
nam55953392nam
nim57142962nim
nims66226892nims
nisi45823252nisi
nom510450642nom
ohm86523012ohm
om48553002_om
oms56337512oms
os211359882os_
ose38147342ose
pam77858392pam
pis56362042pis_
pish96127922pish
piso66727572piso
piss65033342piss
pom78249912pom
prism94820262prism
psi56621622psi
pst57932512pst
qis126934392qis_
ram56867272ram
rem56150042rem
rim56052282rim
rims65936312rims
rise45945242rise
risk85724112risk
rom59855632rom
rum56644642rum
seism75019022seism
sh56828522_sh
si29149582_si
sib56850322sib
sic55847882sic
sima64730792sima
simp85228782simp
sims65737182sims
sin36265902sin
sip57656022sip
sir35746682sir
sis37360552sis
sit35877762sit
six105339752six
so28855442_so
som59153812som
sum56346012sum
tam58663422tam
tis37056652tis_
tom514358052tom
tsk75814732tsk
um47338832_um
umm711921262umm
us26937432us_
use36835162use
vim87437032vim
vims95423322vims
vis66747622vis_
visa76323882visa
vise75632682vise
vum85428652vum
wis66552342wis_
wise75737352wise
wish107228742wish
wisp97124082wisp
wiss75630552wiss
wist78049302wist
xis106935342xis_
yam87448992yam
yom88043442yom
yum86132822yum

Search took 1 second 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 Filter178691140840.280638182.1
2DLD Change Limit140841850.58024282.8
3Display Results1851850.0306166.7
 (SQL Overall)1786911850.890200776.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.