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

307 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
disrates9111815(None) 
disrate81418521disrate_
disrated10915571disrated
misrates101318241misrates
citrates102315092citrates
derates84028892d_erates
dictates11311382dictates
dilates83220662di_lates
diorites9313522diorites
discases112014502discases
diseases92415812diseases
disgraces1348452disgraces
disputes1139652disputes
disrobes1139742disrobes
dissaves1239412dissaves
distastes1039632distastes
distaves12311402distaves
librates103412952librates
migrates111112852migrates
misdates111113632misdates
mismates121114562mismates
misrate91319142misrate_
misrated111315382misrated
nitrates82516222nitrates
picrates122013212picrates
pirates93020332pi_rates
titrates82314662titrates
vibrates132210612vibrates
acierates11310813acierates
aerates74627493_aerates
airdates939723airdates
amirates101114793amirates
berates94126873_berates
bistate9313823bistate_
borates94823013_borates
carates95630613_carates
caseates10313713caseates
castrates11312673castrates
cerates95428253_cerates
ciliates10413453ciliates
cirrate92413493cirrate_
citrate92216803citrate_
citrated112712253citrated
crates85736063__crates
curates95323833_curates
dates65639153d___ates
deaerates10313643deaerates
dealates92716683dealates
debates103718533d_ebates
decorates12314743decorates
deflates123013943deflates
degrades11269923degrades
delates83526283d_elates
denigrates1298113denigrates
denitrates1169513denitrates
depraves1436873depraves
depurates1239823depurates
derate74531233d_erate_
derated93623503d_erated
derats74625063d_erat_s
desecrates1348843desecrates
desolates10311793desolates
despites11410313despites
deviates12312733deviates
diabases1137223diabases
diabetes1147023diabetes
diamantes1296263diamantes
diaries83321953diar_ies
diastases1047073diastases
dictate10311663dictate_
dictated1239203dictated
diereses938693diereses
digraphs15105753digraphs
diktats1235623diktat_s
dilate73220693di_late_
dilated93115823di_lated
dilater83515653di_later
dilaters92513063di_laters
dilutes82911973di_lutes
dinettes9310193dinettes
dioramas1145513dioramas
diorite8314913diorite_
dioxanes1645373dioxanes
dipsades1246493dipsades
diquats1745983diquat_s
dirams94413703di_ra_ms
dirges84915103di_r_ges
dirties83119383di_rties
dirts66824463di_r_t_s
disables11410903disables
disarmed1238643disarmed
disarmer1138033disarmer
disarmers1246943disarmers
disarms1039043dis_arms
disaster949943disaster
disasters1039153disasters
disbands1237353disbands
disbars10310323disba_rs
discanted1339333discanted
discants112912023discants
discards1238913discards
discase102912863discase_
discased122510853discased
discrete11410283discrete_
discuses113112863discuses
disdains1037913disdains
disease83213843disease_
diseased103011713diseased
diseuses93112763diseuses
disgrace1248283disgrace_
disgraced1446743disgraced
disgracer1346183disgracer
disgracers1444733disgracers
dishes104622653dis__hes
dishrags1346203dishra_gs
dishwares1645863dishwares
dishwater1644903dishwater
dishwaters1744023dishwaters
disinter9310673disinter
disinters1039713disinters
diskettes1446573diskettes
dislikes132810843dislikes
dislocates13108323dislocates
dismaler1137903dismaler
dismalest1246313dismalest
dismals102010243disma_ls
dismantles1344333dismantles
dismasted1346833dismasted
dismasts1137513dismasts
dismayed1535743dismayed
dismays13237433disma_ys
dismes95617673dis__mes
disparages1446043disparages
disparate1249053disparate_
disparted1338853disparted
disparts11109953disparts
dispatch1654553dispatch
dispatches1874583dispatches
displaces1448593displaces
disposes11313823disposes
dispraise1248343dispraise
dispraises1347393dispraises
disprizes2148113disprizes
disproves15158513disproves
dispute1039083dispute_
disputed1238353disputed
disputer1137973disputer
disputers1236613disputers
disrating11714553disrating
disrelated1247343disrelated
disreputes13144523disreputes
disrobe1038993disrobe_
disrobed1238093disrobed
disrober1147623disrober
disrobers1246383disrobers
disrooted1147623disrooted
disroots948623disroots
disrupted1345973disrupted
disrupter1244723disrupter
disrupters1343933disrupters
disrupts1145293disrupts
dissave1139413dissave_
dissaved1337313dissaved
disseated11711083disseated
disseats93211503disseat_s
dissertates1245343dissertates
disses75225963dis__ses
dissipates1346553dissipates
dissuades1166243dissuades
distaffs1565083distaffs
distains9413603distains
distances12311653distances
distaste939943distaste_
distasted1137963distasted
distomes11314163distomes
distracted1448873distracted
distracts1249283distracts
distrains10411333distrains
distraite10611483distraite_
disulfates14145363disulfates
disunites1088673disunites
disuses84015413dis_uses
disvalues1344503disvalues
disyokes1656503disyokes
dites66339153di___tes
diureses936453diureses
divagates1444733divagates
donates83217223d_onates
dosages92310803dos_ages
drakes114715863d__rakes
drapes95419653d__rapes
drats66628373d__rat_s
emigrates1248583emigrates
emirates101214853emirates
estates74520183_estates
ferrates113013423ferrates
filiates11412663filiates
filtrates1247733filtrates
fissate103010033fissate_
fixates1737393fi_xates
gestates93213733gestates
gisarmes1144433gisarmes
grates75429893__grates
gyrates113610263_gyrates
hydrates15229413hydrates
ideates8313733_ideates
ingates82716913_ingates
ingrates9514173ingrates
inmates92715783_inmates
instates81615833instates
iodates8312903_iodates
irades74517393_i_rades
irate55627983_i_rate_
irater65218353_i_rater
iratest7312483_i_ratest
isolates8613513_isolates
iterates81317823iterates
karates115617473_karates
kismats13257843kismat_s
liberates111012943liberates
librate93214233librate_
librated113110313librated
ligates82318383li_gates
liquates1737453liquates
literates91415653literates
lustrates939463lustrates
lysates10317473lys_ates
migrate101314173migrate_
migrated121110513migrated
mirages102213533mi_rages
misate81222693mis_ate_
miscites12313783miscites
miscreates1448103miscreates
misdate101413963misdate_
misdated121211123misdated
miseases102614343miseases
miseaten10310773miseaten
miseats92815793miseat_s
misframes1646633misframes
misgrades1347363misgrades
mismakes16129883mismakes
mismate111415353mismate_
mismated131111333mismated
misnames12119883misnames
mispages13311183mispages
misraise10410523misraise
misraises1149933misraises
misrelates1247623misrelates
misroutes1148313misroutes
misrules1039383misrules
misstates11710633misstates
mistakes141213413mistakes
mistraces13312293mistraces
miswrites1447983miswrites
narrates8312763narrates
nictates1039593nictates
nidates8311893ni_dates
niobates1037283niobates
nitrate72017013nitrate_
nitrated92213153nitrated
nitrites82313453nitrites
operates10515413operates
orates64328613__orates
outrates82421373outrates
phorates13413043phorates
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirate82322883pi_rate_
pirated102515613pi_rated
pistes85325633pis__tes
prates84633163__prates
priorates11410763priorates
prorates10418073prorates
rates55352013___rates
recrates102420373recrates
regrates92618403regrates
reslates83619503reslates
restates83423433restates
sates54949323__s_ates
serrates82617023serrates
sinuates8310963sinuates
situates8310373situates
skates104219403__skates
slates64934063__slates
spates85028173__spates
states64337083__states
testates83615453testates
tirades8311723ti_rades
tisanes7311853tis_anes
titrate72215573titrate_
titrated92611683titrated
uncrates10314563uncrates
unstates81314993unstates
uprates93814863_uprates
upstates10189643upstates
urates65027763__urates
vibrate122811523vibrate_
vibrated14228393vibrated
vibratos13217483vibratos
vicarates1487623vicarates
violates11311193violates
virgates1237923virgates
visages1138693vis_ages
vitiates112311433vitiates
vizirates2144663vizirates
zincates1937743zincates

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623076.75021653.6
3Display Results3073070.1232495.9
 (SQL Overall)1786913077.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.