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

148 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
rissoles83911(None) 
rissole739781rissole_
dissolves1346232dissolves
insoles73516242_insoles
midsoles1137762midsoles
missiles103015082missiles
pistoles102514722pistoles
rassles73513922rass_les
resoles73823652r_esoles
risibles1035782risibles
airholes1138033airholes
aisles64721143ai_s_les
anisoles81010123anisoles
assholes1146743assholes
bricoles122610303bri_coles
brisses94314313briss__es
bristles101510433bri_stles
bristols1046773bristol_s
cineoles10109403cineoles
ciscoes113610733cisco_es
cissies94116153ciss_ies
cissoids1145363cissoids
citoles9312553ci_toles
consoles103216153consoles
diastoles1047493diastoles
diazoles1836323diazoles
dipoles101013753di_poles
disables11410903disables
disposes11313823disposes
disrobes1139743disrobes
dissaves1239413dissaves
disses75225963diss__es
dissolve1246103dissolve
dissolved1445593dissolved
dissolver1345623dissolver
dissolvers1444643dissolvers
distomes11314163distomes
disyokes1656503disyokes
fishpoles1743633fishpoles
fissile10269653fissile_
fissures1136573fissures
frijoles1834373fri_joles
frissons1145043frisso_ns
gessoes838293gesso_es
girasoles1083713girasoles
gristles9189203gri_stles
hassles103411693hass_les
hirsles101510073hirs_les
hisses94719353hiss__es
hissies103915823hiss_ies
histones11312803histones
indoles83716363_indoles
insole63515863_insole_
isles54220563_i_s_les
issues648803_iss_ues
istles62814983_i_stles
kisses104217333kiss__es
lassoes74613853lasso_es
lisles63416283li_s_les
lissome937583lissome_
midsole1037813midsole_
miscodes13310423miscodes
misdoes10312493misdo_es
misfiles133110983misfiles
mismoves1537293mismoves
misrules1039383misrules
missals93914423missal_s
missels94614813missel_s
misses85130873miss__es
missies93423983miss_ies
missile92815403missile_
missises103513693missises
missives133212843missives
missorts1038323missorts
missouts1037623missouts
misstyles1445023misstyles
missuses10309683missuses
misyokes1735513misyokes
oilholes1146153oilholes
orioles7412993ori__oles
osmoles9138363_osmoles
outsoles8813113outsoles
pieholes13168913pieholes
pinholes131810663pinholes
pinoles93418703pi_noles
pishoges1446953pishoges
pisses84525083piss__es
pissoirs1044693pissoirs
pistole92414313pistole_
pistoled11259593pistoled
pistols93213983pistol_s
plimsoles1343573plimsoles
posoles9314883_posoles
prisses94816713priss__es
prissies101712003priss_ies
rampoles1238893rampoles
rassle63813203rass_le_
rassled83310453rass_led
ratholes11312413ratholes
redissolves1551963redissolves
reissues845993reiss_ues
resales74724903r_esales
rescales103414573rescales
rescores105415693rescores
reshoes102316033resho_es
resiles74026543r_esiles
resole64624183r_esole_
resoled84119283r_esoled
resolves113010783r_esolves
restokes125213043restokes
restores85222993restores
restyles1139193restyles
riboses9310443ri_boses
ribosomes1344843ribosomes
riddles93215023ri_ddles
riffles133911163ri_ffles
rifles94217703ri__fles
riles55343643ri___les
rilles64725503ri__lles
rimples113114223ri_mples
rinses64720383rins__es
ripostes10239083ripostes
ripples113513293ri_pples
rises55244043ri_s__es
risible937923risible_
riskless1235763ri_skless
risuses73210923ri_suses
roles56747983r___oles
roscoes9310923rosco_es
roselles8310713roselles
roseolas8107163roseolas
rustles73416413r_ustles
sisses64520603siss__es
sissies73716603siss_ies
slipsoles1143853slipsoles
soles55547923___soles
stoles63927673__stoles
systoles1146483systoles
tissues737463tiss_ues
triazoles1844393triazoles
trisceles1145293trisceles
triskeles1344273triskeles
trisomes1039833tri_somes
tussles737833tuss_les
tussores8316533tussores
viscoses1338343viscoses
wisses94619603wiss__es
wrassles11376713wrass_les

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.1561145455.1
2DLD Change Limit1461621487.62619166.3
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.82822827.2
 
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.