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

104 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
galoshe113539(None) 
galosh1038561galosh_
galoshed1334471galoshed
galoshes1236891galoshes
goloshe1134721goloshe
galore73514852galo_re
golosh1036462golosh_
goloshes1236252goloshes
agarose838673agaros_e
aldose7311093_aldos_e
aloe45540193_alo__e
aloha8513613_alo_ha
alone55732963_alo_ne
arose55832083_aros_e
aslosh966233aslosh_
caboshed1634393caboshed
calash11312433calash_
calashes13310533calashes
caleche14297943caleche
caliche14329953caliche
callose9313663callos_e
calorie92716893calorie
calos74431903calos__
calotte9510563calotte
caroche1469243caroche
cloche134312373_cloche
close76425223_clos_e
clothe114712993_clothe
false84818123fal_s_e
falsie93513853fal_sie
filose96112503filos_e
galah95917633gal_ah_
galahs105512673gal_ahs
galas65731643galas__
gale56347323gal___e
galeae74717453gal_eae
galeate83916783galeate
galere73716673gal_ere
gales65442483gales__
galette84212693galette
galilee8312213galilee
gallate83417123gallate
galls64729323galls__
galoot72719163galo_ot
galoots82410793galoots
galop84716223galo__p
galopade1243953galopade
galoped11138073galoped
galops94712623galo_ps
galores82614323galores
gals57946503gal_s__
gamashes1456943gamashes
ganache1346203ganache
gaols66717573gaols__
gaposis1038423gaposis
garish104516923garish_
garote7717953garo_te
garotte868703garotte
gash86833023ga__sh_
gashed116321973ga__shed
gasher104320373ga__sher
gashes105725153ga__shes
gauche1238553ga_uche
gavotte1174603gavotte
gawsie1038463ga_wsie
glassie8329493glassie
globe84917013g_lo_be
gloss64319623g_los_s
glossa7529163g_lossa
glossae8477283g_lossae
glossed94410073g_lossed
glosser83410813g_losser
glosses84014123g_losses
glossy10549003g_lossy
glost65422933g_los_t
glosts74513813g_losts
glove94516293g_lo_ve
gloze154815983g_lo_ze
goose65925903g_oos_e
gosh86123423g__osh_
grosze16457733g_rosze
gyrose105310253gyros_e
halos85230253halos__
jalousie1543143jalousie
lanose6313593lanos_e
lose45144583__los_e
maltose939783maltos_e
palish114718273palish_
panoche1456383panoche
pilose84514243pilos_e
ramose8314403ramos_e
slosh84514483_slosh_
sloshed11329823_sloshed
sloshes103811803_sloshes
sloshy12366623_sloshy
splosh1186543splosh_
sploshed1434323sploshed
sploshes1336133sploshes
talcose938133talcos_e
vadose1037963vados_e
valise92917643valis_e
valse85117523val_s_e
vamose1159283vamos_e
xylose1636763xylos_e

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271047.25018486.5
3Display Results1041040.0333151.5
 (SQL Overall)1786911047.68923239.8
 
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.