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

285 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
disarm931047(None) 
disarms1039041disarms
diary95016972di_ary
dinar66319892dinar_
dinars75417562dinars
diram84419472dira_m
disarmed1238642disarmed
disarmer1138032disarmer
disbar938512disbar_
disbars10310322disbars
discard11310212discard
dispart101115282dispart
gisarme1044172gisarme
inarm7314422_inarm
misaim10311852misaim
visard103910122visard
alarm76621423_alarm
arm58449623___arm
asarum84610913_asarum
aswarm11107913aswarm
barm86739603__barm
beswarm1445773beswarm
bicarb1238543bicarb
biform1368123biform
binary11312223binary
bistre83815023bistre
bistro8339943bistro
charm126124663_charm
cigar8911803cigar_
cigars9910723cigars
dam67457043d__a_m
damar84117733damar_
damars93814993damars
darb76033533d__arb
dare55848863d__are
dark95133213d__ark
darn56434623d__arn
dart55857873d__art
dastard9279703dastard
datary10310243datary
dear55343603d_ear_
dears65736883d_ears
deary95826843d_eary
debar85517863debar_
debark134210943debark
debars94218043debars
decare93919153decare
deform1259613deform
degerm1037893degerm
deiform1336683deiform
deism84116033deis__m
dekare112811563dekare
demark134211023demark
denar65223293denar_
denari710917353denari
denars74621433denars
denary105316863denary
depart94720563depart
deperm1139363deperm
derm76031893d__erm
desalt7518313desalt
desand84812633desand
descry1256183descry
desert72725493desert
desire7415303desire
desorb95210203desorb
dewar95817733dewar_
dewars105117073dewars
deworm1249523deworm
dharma1276103d_harma
diadem1037583diadem
diagram1147363diagram
dial55935063di_a_l
dials64925343di_als
diastem10318043diastem
diatom939453diatom
diazo15310033di_azo
dicast9315573dicast
dicer85426423dicer_
dicers94720743dicers
dictum1136863dictum
didact10711203didact
diehard1237053diehard
diestrum1145363diestrum
dietary1158663dietary
digamma1343103digamma
digamy1335893digamy
diker105524553diker_
dikers114418793dikers
dilate73220693dilate
dim68146493di___m
dimer85625603dimer_
dimers94321093dimers
diner65632903diner_
dinero75612643dinero
diners75525953diners
dinkum1335893dinkum
diorama1046533diorama
dipsas9359893dipsa_s
dirams94413703dirams
dirdum1036033dirdum
dire56644143di__re
direr64927073direr_
dirham12378273dirham
dirk96326833di__rk
dirl57430023di__rl
dirt55550383di__rt
dis46459893dis___
disable10516433disable
disaffirm1851833disaffirm
disagree1048353disagree
disarmers1246943disarmers
disarming1338803disarming
disarray1244833disarray
disavow1443603disavow
disband1138243disband
disbud10165713disbud
disc76123233dis__c
discant103017253discant
discards1238913discards
discase102912863discase
disced104914653disced
discern1038493discern
disci85815023dis_ci
disclaim1345643disclaim
disco85616073dis_co
discord1139993discord
discos94915213discos
discs85316263dis_cs
discus94512113discus
disdain938513disdain
disease83213843disease
diseur738843diseur
diseurs839403diseurs
dish86328333dis__h
dished114318713dished
dishelm1335833dishelm
dishes104622653dishes
dishrag1246273dishrag
dishware1545433dishware
dishy125712353dis_hy
disk96625833dis__k
disked125015763disked
disks105417473dis_ks
dislimn1056103dislimn
dismal92412243dismal
dismals102010243dismals
dismast10311233dismast
dismay12229473dismay
dismays13237433dismays
disme85716243dis_me
dismes95617673dismes
disown1036953disown
disparts11109953disparts
dispel9310323dispel
disport101015953disport
disrate81418523disrate
diss56434483dis__s
dissave1139413dissave
dissed85220183dissed
dissert83720693dissert
disses75225963disses
distaff1467683distaff
distain8313783distain
distal73615773distal
distant83519953distant
distil73616433distil
distome10313233distome
distort81120333distort
disturb1046233disturb
disuse74012843disuse
dita56032523dita__
ditas65923673dita_s
diva85920883diva__
divan96114843diva_n
divans104612393divans
divas95418583diva_s
diver94827803diver_
divers105024963divers
divert103922813divert
diwan95712553diwa_n
diwans105110373diwans
dorm76834633d__orm
dosage82810003dosage
doser66228563doser_
dosers75723633dosers
dotard839053dotard
dram75832003d_ra_m
dream85120393drea_m
drear65016903drear_
drears74614253drears
dreary104611673dreary
dunam8313733duna_m
dwarf126015243d_warf
farm95934533__farm
fiar76427333fi_ar_
fiars86720833fi_ars
filar84819293filar_
firearm1237193firearm
firm96026453fi__rm
gisarmes1144433gisarmes
guisard954203guisard
harm95637793__harm
hilar85418143hilar_
ihram10310183_ihram
imam81718333_ima_m
imaum9139643_imaum
inarms8410093_inarms
ism56322383_is__m
izar136616013_izar_
izars145112933_izars
jism135514773jis__m
kinara10310373kinara
liar47229683li_ar_
liard65418593li_ard
liars54723163li_ars
lidar6312723lidar_
lidars7310783lidars
lissom837403lissom
lizard16369233lizard
miasm91211093mi_asm
misact10316683misact
misadd1037163misadd
misaims11310113misaims
misate81222693misate
miser75430403miser_
misers85025703misers
misery114113543misery
misform1437513misform
mismark1536703mismark
mispart111113773mispart
misterm114314513misterm
nizam16310253niza_m
osar46820953_osar_
picara10311903picara
picaro10311323picaro
pilar75221503pilar_
piscary1437423piscary
prearm104512343prearm
psalm949273_psalm
rearm75923563_rearm
rewarm115913483rewarm
riser55431053riser_
risers64624783risers
ristra6310713ristra
ritard74812083ritard
rosary92810353rosary
sard55344243__sard
sari45444043__sari
sark84938973__sark
sidearm1035963sidearm
simar74920813simar_
simars84916933simars
sisal54217733sisa_l
sisals63013573sisals
sistra639333sistra
sistrum946563sistrum
sitar54820543sitar_
sitars65417593sitars
sizar145214993sizar_
sizars154812623sizars
smarm95517603_smarm
swarm106218833_swarm
tharm105916643_tharm
tiara5315913ti_ara
tisane6311573tisane
tsar47819803_tsar_
tsars56717113_tsars
unarm7314453_unarm
vicar10513863vicar_
vicars11712263vicars
visa76323873visa__
visaed104110503visaed
visage1049083visage
visards11328153visards
visas84317653visa_s
visor82512833visor_
visors92912223visors
vivary1536983vivary
vizard19458853vizard
warm95935673__warm
wisdom1235983wisdom
wiser85522803wiser_
wizard19377713wizard
ziram163912893zira_m

Search took 8 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 Limit1127162857.06315958.7
3Display Results2852850.0933064.5
 (SQL Overall)1786912857.29624491.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.