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

413 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
issuer64662(None) 
issue559211issue_
issued746721issued
issuers746121issuers
issues648801issues
assumer965362assumer
assure6610772assure
assurer767792assurer
fissure1036782fissure
hisser94713792hiss_er
hissier103410502hissier
insure63416602insure
insurer73312802insurer
isomer8310152isomer
issei568572iss_ei
kisser104212452kiss_er
misuser93210442misuser
pisser84416382piss_er
reissuer854522reissuer
sissier73711362sissier
sister64421582sister
suer45334032__suer
tissue637332tissue_
tissued835582tissued
tissues737462tissues
tissuey1033662tissuey
abuser85413683abuser
amuser84712623amuser
answer936893answer
arguer74510543arguer
ashier94714833ashier
ashler9459973ashler
asker96418783_asker
asper75520433_asper
assayer1035573assayer
assert64922583ass_ert
asses55629283ass_es
asset55932263ass_et
assuager944343assuager
assume897563assume
assumed1065293assumed
assumers1064963assumers
assumes967163assumes
assured858373assured
assurers866313assurers
assures7611403assures
assuror754203assuror
aster55434893_aster
baser74828923bas_er
basher115123813basher
baster85333593baster
bisque17257843bisque_
bisques18236893bisques
bister84922763bister
bitsier9379073bitsier
bluer74918493_bluer
bosker123813653bosker
bossier93712423bossier
busher114922203busher
busier85219723busier
busker125517833busker
buster84726493buster
caster85232573caster
causer84117783causer
cissies94116153cissies
cosher114819903cosher
cosier84423753cosier
coster84331293coster
cusser86016093cusser
dasher104318983dasher
diaster82813313diaster
diester83013683diester
disaster949943disaster
diseur738843diseu_r
dishier113613403dishier
disputer1137973disputer
dissed85220183diss_ed
dissert83720693diss_ert
disses75225963diss_es
dissever12107653dissever
dissuader1175083dissuader
disuse74012843disuse_
disused93211033disused
disuses84015413disuses
ditsier83010293ditsier
doser66228563dos_er
dosser74417973dosser
dossier83711693dossier
douser75621633douser
duster74919723duster
easier64218463easier
easter65027983easter
ensue54013833ensue_
ensued73610483ensued
ensues63313813ensues
ensure63416003ensure
ensurer73011903ensurer
esker94412983_esker
essayer1033943essayer
esses56422973ess_es
ester54727713_ester
faster94625773faster
fester94723513fester
fibster12146533fibster
fisher124917143fisher
fishier13359853fishier
fissured1235183fissured
fissures1136573fissures
foster94322223foster
fusser94813773fusser
fussier103610673fussier
gasher104320373gasher
gasper94515543gasper
gasser75017773gasser
gassier83812573gassier
gaster75027353gaster
gluer65116773_gluer
gusher104115773gusher
hipster12288783hipster
hissed104114453hiss_ed
hissers104112313hiss_ers
hisses94719353hiss_es
hissies103915823hissies
hoser811529763hos_er
hosier94219613hosier
houser95322283houser
husker134212703husker
icier74313753i_cier
icker114018443i_cker
ickier12439923ickier
idler65015663i_dler
iffier1236763iffier
iller54821293i_ller
imager9108123imager
imbue939483imbue_
imbued1136173imbued
imbues1037983imbues
immure1036033immure
impure1038383impure
impurer1136483impurer
imputer1136533imputer
inaner62213543inaner
incher114114033incher
incur72212253incu_r
inducer10318763inducer
indue63516673indue_
indued83411653indued
indues73515263indues
infer84215033i_nfer
infuser10298323infuser
inhumer1275383inhumer
injure133410863injure
injurer14318473injurer
inker94421093i_nker
inkier104013783inkier
inlier63615363inlier
inner54920633i_nner
insaner7310443insaner
insert64325253ins_ert
inset54430863ins_et
insider849733insider
insister888783insister
instar6310013instar
instep838193instep
insular7138703insular
insult62813673insult
insulter836883insulter
insured83714253insured
insurers83710133insurers
insures73117263insures
inter55028493i_nter
inure54119053i_nure
irater65218353irater
ironer64216453ironer
isle45121703i_sle_
isled64615993i_sled
isles54220563i_sles
islet54527553i_slet
isobar836143isobar
isohel935483isohel
isomers9310043isomers
isseis638563isseis
issuant748263issuant
issuing836053issuing
istle52214713istle_
istles62814983istles
ither84617603i_ther
jasper154610383jasper
jester134319153jester
josher164312963josher
juster134617013juster
kasher134915033kasher
kiester11329973kiester
kissed114412853kiss_ed
kissers114211293kiss_ers
kisses104217333kiss_es
kosher134412973kosher
laser54633323las_er
lasher94824533lasher
lassoer7379383lassoer
laster64830633laster
lesser63514853lesser
lisper84114433lisper
lister64527253lister
loser54728673los_er
lusher93818763lusher
luster64023673luster
maser75029973mas_er
masher114123203masher
masker124416103masker
masquer18266463masquer
masseur935703masseur
massier93615223massier
master84831343master
messier93412923messier
minster93914323minster
misaver1249813misaver
miscue10412223miscue_
miscued1239293miscued
miscues11312393miscues
misdoer1048633misdoer
miser75430403mis_er
missed94423603miss_ed
missel85216523miss_el
misses85130873miss_es
misset85028153miss_et
missies93423983missies
missteer1037223missteer
misstep11158463misstep
missuit9911303missuit
missus85312293missu_s
missuses10309683missuses
mister84728563mister
mistier93418713mistier
misuse83213643misuse_
misused104111283misused
misusers10348083misusers
misuses93216023misuses
mosher114719793mosher
mosser84618273mosser
mossier94413813mossier
mouser85822443mouser
muser76024123mus_er
musher113820573musher
mussier93314363mussier
muster84724523muster
nester64124183nester
nosher94616363nosher
nosier63716323nosier
osier53518013_osier
ossuary1043943ossuary
ostler63312193ostler
ouster64223733ouster
oyster94111703oyster
passer84721033passer
paster85734373paster
pauser84415963pauser
pester84827593pester
piaster93012883piaster
pilsner935343pilsner
pisher114317753pisher
pissed94816933piss_ed
pissers95014753piss_ers
pisses84525083piss_es
pissoir945043pissoir
poser75128773pos_er
poseur8419403poseur
posher115018163posher
poster84129173poster
prissier10157873prissier
pursuer9338893pursuer
pusher114318283pusher
pussier93711993pussier
queuer15357253queuer
raser55633413ras_er
rasher95024123rasher
rasper83917333rasper
raster64731443raster
rasure6311423rasure
reissue745873reissue_
reissued944903reissued
reissuers954033reissuers
reissues845993reissues
rescuer939033rescuer
rester63832433rester
resumer9410113resumer
rinser64317213rins_er
riser55431053ris_er
risker105414493risker
riskier1138423riskier
risque15227453risque_
risuses73210923risuses
rosier64221263rosier
roster64329083roster
rouser65224083rouser
ruer46127563__ruer
rusher94019653rusher
saber75330243_saber
safer84721813_safer
sager65432053_sager
saker95132023_saker
saner54334323_saner
sassier73413233sassier
saucer84314103_saucer
sauger74316253_sauger
saver84831253_saver
sawer85026213_sawer
sayer84926553_sayer
scissure1043273scissure
seder64826753_seder
seer45547043__seer
ser36752403__s_er
serer55935503_serer
sever85426053_sever
sewer84426213_sewer
sheer84726893_sheer
shier85428943_shier
shoer84722163_shoer
shyer114714783_shyer
sicker124023903sicker
sidler74716963sidler
sieur5911893sieu_r
sifter94516233sifter
sigher103813703sigher
signer74015633signer
siker95326033_siker
siller64026063siller
silver93815813silver
simmer104115353simmer
simper103616293simper
singer74227313singer
sinker103620903sinker
sinner64320603sinner
sinter63625923sinter
sipper103920993sipper
sises55233833sis_es
sisses64520603sisses
sissies73716603sissies
sisters73721593sisters
sitter63323383sitter
siver85728613_siver
sizer145521813_sizer
sizier1514813393sizier
skier95119593_skier
slier54827243_slier
slue45332193_slue_
slued64220513_slued
slues54527173_slues
slur45525153_slu_r
slyer85515123_slyer
sneer54919953_sneer
sober74822413_sober
sorer56236583_sorer
sour45935893_sou_r
sourer63620213_sourer
souter64225923_souter
sower85229313_sower
speer74623903_speer
spier75728033_spier
spue66025523_spue_
spued84918473_spued
spues75025383_spues
spur65321193_spu_r
squeg1588033_squeg
steer55423863_steer
suber74924503_suber
sue35651463__sue_
sued56537933__sued
suers55128483__suers
sues46247653__sues
suet46754823__suet
super74924483_super
sure45447413__sure
surer54833093_surer
sweer84918573_sweer
taster64930573taster
tester64227153tester
tipsier9268893tipsier
tipster9299053tipster
tissual745193tissual
tissular843813tissular
tosser64215663tosser
truer54916643_truer
tusker104212193tusker
tusser64615833tusser
tussur6357293tussu_r
ulster63712103ulster
unissued934683unissued
unsure62815413unsure
user45023003_us_er
usher84517763_usher
usque14137733usque_
usques15126803usques
usurer638103usurer
vaguer10448443vaguer
valuer93911443valuer
vaster94521023vaster
vesper1138083vesper
visiter1038863visiter
voguer10468403voguer
washer124720393washer
waster95228943waster
wester94222893wester
wiser85522803wis_er
wisher123617063wisher
wispier12249403wispier
wissed104114643wiss_ed
wisses94619603wiss_es
wussier10408083wussier
xyster16366803xyster
yester93417983yester
zester153617793zester
zoster153715853zoster

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164137.86014340.5
3Display Results4134130.2661552.6
 (SQL Overall)1786914138.26621617.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.