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

165 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
dissaves123941(None) 
dissave1139411dissave_
dissaved1337311dissaved
distaves12311391distaves
dipsades1246492dipsades
discases112014502discases
diseases92415812diseases
disrates91118142disrates
disserves1388062disserves
disses75225962diss__es
dissever12107652dissever
dissevers1386862dissevers
dissolves1346232dissolves
dissuades1166242dissuades
missives133212842missives
airwaves1444723airwaves
cassavas1344803cassavas
cissies94116153ciss_ies
dassies84418663dass_ies
deaves105319533d__eaves
deleaves1248063deleaves
depraves1436873depraves
deserves12109893deserves
diabases1137223diabases
diastases1047063diastases
dictates11311373dictates
dieses75218693dies__es
dilates83220653di_lates
dioxanes1645373dioxanes
dipsas9359893dipsa__s
disables11410903disables
disarms1039043di_sarms
disaster949943disaster
disasters1039143disasters
disavow1443603di_savow
disavows1544043di_savows
disbands1237353disbands
disbars10310323disba_rs
discants112912023discants
discards1238913discards
discase102912863discase_
discased122510843discased
discover1439563discover
discovers1538153discovers
discuses113112853discuses
disdains1037913disdains
disease83213843disease_
diseased103011703diseased
diseuses93112753diseuses
disfavor1542873disfavor
disfavors1643263disfavors
disgraces1348453disgraces
dishes104622653di_s_hes
dishevel1564703dishevel
dishevels1653633dishevels
dishwares1645863dishwares
disinvest1346803disinvest
dislikes132810843dislikes
dismaler1137903dismaler
dismalest1246313dismalest
dismals102010243disma_ls
dismasts1137513dismasts
dismayed1535743dismayed
dismays13237433disma_ys
dismes95617673di_s_mes
disparts11109953disparts
displaces1448593displaces
disposes11313813disposes
disproves15158513disproves
disputes1139653disputes
disrate81418523disrate_
disrated10915573disrated
disrobes1139743disrobes
dissaving1436953dissaving
disseated11711073disseated
disseats93211503disseats
dissects11279243dissects
dissed85220173diss__ed
disseise939843disseise
disseises1039323disseises
disseizes1946823disseizes
dissents93411863dissents
disserts92411813disserts
disserve1287443disserve_
disserved14107003disserved
dissipates1346543dissipates
dissolve1246103dissolve_
dissolved1445593dissolved
dissolver1345623dissolver
dissolvers1444643dissolvers
dissuade1065933dissuade_
dissuaded1265423dissuaded
dissuader1175083dissuader
dissuaders1273823dissuaders
distaffs1565073distaffs
distains9413603distains
distances12311653distances
distastes1039623distastes
distomes11314163distomes
disuses84015403di_suses
disvalues1344503disvalues
disyokes1656503disyokes
dives95832403di___ves
dosages92310803d_osages
dossals8379293dossa_ls
dosses76126273doss__es
dressages1144153dressages
enslaves1136393enslaves
fissate103010033fissate_
fissures1136573fissures
glissades1143313glissades
hisses94719353hiss__es
hissies103915823hiss_ies
issues648803_iss_ues
jussives1833843jussives
kisses104217333kiss__es
massages1159883massages
messages1138233messages
misaver1249813mi_saver
misavers1348053mi_savers
misdates111113623misdates
miseases102614343miseases
misgave13298283misgave_
misgives14329293misgives
mislives132912153mislives
mismakes16129883mismakes
mismates121114553mismates
mismoves1537293mismoves
misnames12119883misnames
mispages13311183mispages
misrates101318233misrates
missals93914423missa_ls
missays124010253missa_ys
misses85130873miss__es
misshapes1645913misshapes
missies93423983miss_ies
missiles103015083missiles
missises103513693missises
missive122413143missive_
misspaces1546513misspaces
misstates11710623misstates
missuses10309683missuses
mistakes141213403mistakes
misusages1244973misusages
passades1139203passades
passages1139513passages
passives13228823passives
piasavas1343333piasavas
piassavas1442173piassavas
pissants1097363pissants
pisses84525083piss__es
reshaves1438733reshaves
rissoles839113rissoles
saves85838633___saves
shaves125224933__shaves
sisses64520603siss__es
sissies73716603siss_ies
slaves95023023__slaves
soaves94218673__soaves
staves94525193__staves
tipstaves1443343tipstaves
tisanes7311853ti_sanes
tissues737463tiss_ues
visages1138693vi_sages
wisses94619603wiss__es

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.1731032896.0
2DLD Change Limit1461621657.73318901.1
3Display Results1651650.0802062.5
 (SQL Overall)1786911657.98622375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.