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 “dipsades” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
dipsades124649(None) 
depsides1238502depsides
diopsides1345282diopsides
dipsas9359892dipsa__s
dissaves1239412dissaves
dissuades1166242dissuades
apsides103911303_apsides
biplanes1238573biplanes
crusades1146333crusades
dapsones1138383dapsones
daysides1335963daysides
decades113615513d_ecades
degrades11269923degrades
deplanes11311213deplanes
depraves1436873depraves
depside1138403depside_
diabases1137223diabases
diadem1037583di__adem
diadems1135393di__adems
diamides1238823diamides
diapsids1244753diapsid_s
diastases1047073diastases
dictates11311383dictates
dieses75218693dies__es
dilates83220663di_lates
diodes83915783di__odes
diopside1245643diopside_
dioptases1245903dioptases
dioxanes1645373dioxanes
dioxides1756203dioxides
diphase1387273diphase_
diploes101111493dip_loes
diploses111110323diploses
dipodies1238413dipodies
dipoles101013753dip_oles
dipshits1445263dipshits
dipsos95310053dips__os
disables11410903di_sables
disarms1039043di_sarms
discases112014503discases
diseases92415813diseases
dishes104622653di_s_hes
dismes95617673di_s_mes
disparts11109953disparts
displaces1448593displaces
displodes1347863displodes
disposes11313823disposes
disputes1139653disputes
disrates91118153disrates
dissave1139413dissave_
dissaved1337313dissaved
disses75225963di_s_ses
dissuade1065933dissuade_
dissuaded1265433dissuaded
dissuader1175083dissuader
dissuaders1273833dissuaders
distaves12311403distaves
disuses84015413di_suses
divides123211453di_vides
dolmades1245463dolmades
dosages92310803d_osages
dryades12395633d_ryades
episodes1145913episodes
gipsies1039903gips_ies
glissades1143313glissades
insides8512653_insides
invades11118293_invades
irades74517393_i_rades
limeades11116643limeades
lipases9209483lip_ases
lipides103810623lip_ides
misadds1136303mi_sadds
mispages13311183mispages
passades1139203passades
pesades10310903_pesades
pipages1289423pip_ages
pipeages1336423pipeages
respades1139853respades
ripsawed1442533ripsawed
ripsaws1243823ripsa_ws
riptides1136413riptides
sades65239893___sades
shipsides1544883shipsides
spades94222583_sp_ades
tipstaves1443353tipstaves
tirades8311723ti_rades
tisanes7311853ti_sanes
topsides1137203topsides
torsades937213torsades
tsades74310993__tsades
upsides10319633_upsides
visages1138693vi_sages

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 Filter1786911461620.440406115.9
2DLD Change Limit146162927.62319173.8
3Display Results92920.0332787.9
 (SQL Overall)178691928.09622071.5
 
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.