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
ism5632238(None) 
is27048211is_
isms66213471isms
jism135514771jism
sim56553141sim
agism84614062agism
aim57858212aim
aims67738182aims
ais39083572ais_
am411875562_am
arm58449622arm
as211083072as_
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
bam78560142bam
bis56860662bis_
bise66437102bise
bisk106523352bisk
bum75342692bum
cam78058982cam
cis57748032cis_
cist67244962cist
cum76440162cum
cwm106815082cwm
dam67457042dam
deism84116032deism
dim68146492dim
dims75435022dims
dis46459892dis_
disc76123232disc
dish86328332dish
disk96625832disk
disme85716242disme
diss56434482diss
dom69752442dom
elm57531742elm
em49445152_em
ems56435492ems
es29048222es_
ess36030882ess
fem86040732fem
film94828172film
firm96026452firm
fisc96819752fisc
fish106926272fish
fist76248422fist
gam67060062gam
gem66840222gem
gismo848862gismo
gist56046762gist
gum67439532gum
gym95719062gym
ham86363282ham
hem86148732hem
him86247662him
hims95230972hims
his66359502his_
hisn79620932hisn
hiss75629212hiss
hist76551542hist
hm78126732_hm
hmm106218992hmm
hum85542932hum
iamb86623732iamb
ice56737242ice
ich86227742ich
ick97329322ick
icy86322122icy
id38941842i_d
idem76121062idem
ids47535472ids
if57239952i_f
iff96730392iff
ifs67124242ifs
igg57116792igg
ilk78325302ilk
ill37437092ill
imam81718332imam
immy114611832immy
imp76626972imp
in28150862i_n
ink76433632ink
inn36727432inn
ins35945602ins
ion36051022ion
ire36943172ire
irk76426362irk
isba61310882isba
isle45121702isle
it28455682i_t
item65620382item
its35538832its
ivy96317442ivy
jam126942522jam
jisms14458002jisms
kis78051482kis_
kiss85227402kiss
kist86540802kist
lam57666712lam
lis37162272lis_
lisp68926882lisp
list47055342list
lum55542932lum
mem77943472mem
miasm91211092miasm
mim76048422mim
mis58162622mis_
mise66043582mise
miso67229902miso
miss65339422miss
mist66154532mist
mm67826812_mm
mom78853162mom
mum76643612mum
nam55953392nam
nim57142952nim
nims66226882nims
nisi45823242nisi
nom510450642nom
ohm86523012ohm
om48553002_om
oms56337512oms
os211359882os_
ose38147342ose
pam77858392pam
pis56362032pis_
pish96127912pish
piso66727562piso
piss65033332piss
pom78249912pom
prism94820262prism
psi56621622psi
pst57932512pst
qis126934382qis_
ram56867272ram
rem56150042rem
rim56052272rim
rims65936302rims
rise45945232rise
risk85724102risk
rom59855632rom
rum56644642rum
seism75019022seism
sh56828522_sh
si29149572_si
sib56850312sib
sic55847872sic
sima64730782sima
simp85228772simp
sims65737172sims
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
so28855442_so
som59153812som
sum56346012sum
tam58663422tam
tis37056642tis_
tom514358052tom
tsk75814732tsk
um47338832_um
umm711921262umm
us26937432us_
use36835162use
vim87437022vim
vims95423312vims
vis66747612vis_
visa76323872visa
vise75632672vise
vum85428652vum
wis66552332wis_
wise75737342wise
wish107228732wish
wisp97124072wisp
wiss75630542wiss
wist78049292wist
xis106935332xis_
yam87448992yam
yom88043442yom
yum86132822yum

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 Filter178691140840.516346300.4
2DLD Change Limit140841850.75018778.7
3Display Results1851850.0632936.5
 (SQL Overall)1786911851.329134455.2
 
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.