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

205 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
dormant10281437(None) 
formant123416001formant
dolman95312402dolman_
dolmans10479682dolmans
doorman1037062doorman_
doormat1059072doorma_t
dopant9316132do_pant
dormancy1644422dormancy
dormient1148452dormient
dormin9312312dormin_
dormins10311272dormins
durmast1037622durmast
formants13269952formants
format113021352forma_t
gormand1157452gormand
mordant10312402mordant
odorant8411392odor_ant
torment9316172torment
adamant101110443adamant
adornment1246283adornment
airman82414223airman_
arrant6623253_arrant
barman103519703barman_
borane84620213bor_ane
bowman13129853bowman_
brant74742173_br_ant
carman103920743carman_
clamant11312433clamant
command14399213command
comment1310317703comment
coolant9316463coolant
coranto9311893cor_anto
corban10314693corban_
corbans11313173corbans
cormorant1348573cormorant
corybant1547573corybant
courant9317973courant
cowman13910373cowman_
currant9314173currant
daman84821163d_aman_
damans94715983d_amans
decant93524223d_ecant
defiant11311923defiant
demand104314253d_emand
demast9517063d_emast
dement93825153d_ement
derat65044083der_a_t
derma84918513derma__
dermal93614343derma_l
dermas94116813derma_s
descant104315593descant
desman9311693desman_
desmans1039003desmans
deviant11311313deviant
diamante1186423diamante
diriment11410743diriment
discant103017263discant
dismast10311233dismast
distant83519953distant
doat56947673do__a_t
docent92918683do_cent
document1348663document
dogbane1135653dogbane
dogcart1148043dogcart
dogma96112463dogma__
dogmas105011243dogma_s
dogmata1145143dogmata
dogvane1243853dogvane
dolma86214173dolma__
dolmas95213043dolma_s
dolmen93911373dolmen_
dolmens10388693dolmens
domain9511323do_main
domaine10610503do_maine
domains10510873do_mains
domal85619203do_ma_l
dominant1149523dominant
domine92918253do_mine
doming104218393do_ming
domino92611493do_mino
dooming113112533dooming
doormats1145413doormats
doormen1036753doormen_
dopants1038433do_pants
dorado838813dor_ado
dorhawk1841853dorhawk
dorm76834633dorm___
dormer94415903dorm_er
dormers104313923dormers
dormice1237133dormice
dormie9312623dorm_ie
dorms85723843dorm__s
dormy115817473dorm__y
dorsa64617283dorsa__
dorsad8408973dorsa_d
dorsal74613943dorsa_l
dorsals84110843dorsals
douma85817703douma__
doumas95314813douma_s
draft95526683d_r_aft
drank104816203d_r_ank
drat56247833d_r_a_t
dreamt94615713d_reamt
dromon939363dromon_
dromond1135473dromond
dromons1038193dromons
durian7312003durian_
durians839573durians
durmasts1144093durmasts
errant6618733_errant
ferment12315573ferment
firman112211343firman_
firmans12238523firmans
foeman11311233foeman_
foment113718303fo_ment
fondant11311143fondant
foreman12312363foreman_
foremast1348613foremast
forgat104018583forga_t
forint9325023for_int
formal113215203forma_l
formals123312893formals
formate123115093formate
formats123113573formats
forming133615733forming
fornent10312933fornent
forwent13310533forwent
gardant9314463gardant
garment10315233garment
german9611983german_
germane1049663germane
germans1079473germans
gormands1266563gormands
gorming112810833gorming
gourmand1243263gourmand
grant64840023_gr_ant
hogmane1336343hogmane
hormone12410503hormone
horrent10313553horrent
informant1446473informant
jordan1468063jordan_
jordans1566833jordans
jurant134216553jur_ant
korat94934433kor_a_t
korma115913073korma__
kormas124511233korma_s
loment84021473lo_ment
loran55925093lor_an_
lorans65117603lor_ans
merman10513863merman_
moment103319683mo_ment
mordants1137143mordants
mordent10313993mordent
morgan9311373morgan_
morgans10310123morgans
nondormant1355563nondormant
nonman8412363nonman_
norland837163norland
normal83213533norma_l
normals92510903normals
normande1145943normande
octant81216553_octant
oddment1145923oddment
odorants946043odor_ants
orang65119943_or_ang
organ6915393_organ_
organa789213_organa
organs7912913_organs
orient6322533_orient
permeant12310913permeant
portent93619643portent
potman102813573potman_
rant45864683__r_ant
riant55833153__riant
rodman949713rodman_
roman75424823ro_man_
romano84912943ro_mano
romans84620243ro_mans
romaunt947803ro_maunt
sarment9318763sarment
servant10313633servant
socman1039813socman_
soman75024903so_man_
somans84619303so_mans
sonant6621953so_nant
sorbent92915243sorbent
toman75724053to_man_
tomans85419133to_mans
topmast1138123topmast
torments10310453torments
torrent7313413torrent
towmont1277633towmont
truant6315783_truant
tyrant9315333tyr_ant
variant10316803variant
varment12313243varment
varmint12311683varmint
verdant11313293verdant
versant10313833versant
volant9316323vo_lant
warrant10614243warrant
woman105818003wo_man_
womans114613653wo_mans
workman1635613workman_
worming132811243worming

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272056.07622058.4
3Display Results2052050.0802562.5
 (SQL Overall)1786912056.54627297.7
 
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.