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

155 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
gauchos134590(None) 
gaucho1256221gaucho_
anchos114214892_anchos
gauche1238552gauch_e
gaucher1337232gaucher
gauchest1436292gauchest
guacos94410312guac_os
machos135217492ma_chos
nachos115014182na_chos
ranchos123911392ranchos
sauchs115112232sauch_s
wauchts15285282wauchts
abmhos1334973_abmhos
aches106132293_a_ches
achoo10315083_a_choo
ahchoo1445713_ahchoo
ancho104515303_ancho_
anchor113911973_anchor
anchors123912953_anchors
arches114822043_arches
archon11311753_archon
archons12311583_archons
audios72312283_audios
aughts104710243_aughts
author939763_author
authors10311853_authors
autos56523323_au_tos
baches135426943ba_ches
bancos104713893banc_os
batches144019613batches
bathos116215633ba_thos
buckos143710893_buckos
cacaos104616183ca_caos
caches137926913ca_ches
cachou13310623ca_chou
cachous14312583ca_chous
canchas143212403canchas
capuches1735513capuches
catches144320773catches
caucus1039613cauc_us
conchos144313963conchos
couches144020473couches
dachas124113253da_chas
datchas1347423datchas
douches134315233douches
echos105216463__echos
faucals12326563faucals
fauces114916153fauc_es
faucets12578443faucets
gabbros12124653gabbros
galagos938143galagos
galahs105512673galah_s
ganaches1437423ganaches
garcon92912483garc_on
garcons102411643garcons
garths104111503garth_s
gascon9339723gasc_on
gascons10289103gascons
gashes105725153ga_shes
gasohol1143533gasohol
gasohols1243723gasohols
gauchely1742743gauchely
gaudies9311973gaudies
gauds75717723gau__ds
gaugers94211713gaugers
gauges85915993gau_ges
gaults74112783gau_lts
gaums86217073gau__ms
gaurs66317993gau__rs
gauss65613453gau__ss
gausses8308693gausses
gauzes164710633gau_zes
gazabos1944453gazabos
gazebos1933493gazebos
gazoos163010223ga_zoos
gazpachos2651343gazpachos
geckos13457433g_eckos
glaucous1144223glaucous
glucans1045293glucans
glucose1045113gluc_ose
glunches1436263glunches
gotchas1334613gotchas
gouaches1436193gouaches
grouches14328213grouches
grutches14285853grutches
guacharos1542373guacharos
guaco85012163guac_o_
guanos73811993g_uanos
gucks123917303g_uc_ks
guiros7389093g_uiros
gulches13398103gulches
gumbos114610873g_umbos
gushes104719033g_ushes
hatches153420273hatches
haughs13408563haugh_s
haunches1656963haunches
heuchs14447923heuch_s
honchos15369573honchos
jucos144111713_juc_os
laches116528343la_ches
laichs115110893laich_s
larches124416443larches
latches123320123latches
laughs10489023laugh_s
launches1387903launches
maches134827233ma_ches
macho126120153ma_cho_
machs125722563ma_ch_s
macros104017013ma_cros
manches143818623manches
marches143921173marches
matches143219783matches
mouches143815963mouches
muches134718993_muches
mucho125013443_mucho_
nachas114914193na_chas
naches114622413na_ches
nacho105414383na_cho_
narcos86714203narc_os
naughts11447513naughts
nautches1336083nautches
ouches114322183_ouches
pachas135017143pa_chas
parches143720003parches
patches143320383patches
pathos115516693pa_thos
paunches1568173paunches
ponchos143410703ponchos
pouches144116743pouches
psychos1765263psychos
rachis114017653ra_chis
ranches123620113ranches
rancho114310853rancho_
ratches123620463ratches
raucous938303raucous
raunches1368053raunches
rouches124217893rouches
ruches114819583_ruches
salchow1544323salchow
salchows1644203salchows
saucers93712133saucers
sauces84919503sauc_es
sauch104918773sauch__
saughs104812053saugh_s
stuccos1153933stuccos
taches114224173ta_ches
tachs105820933ta_ch_s
tacos77023553ta_c_os
touches125118343touches
vouches153914113vouches
wackos155210993wa_ckos
watches153017373watches
waucht14399413wauch_t
waughts14355963waughts
yachts1437023ya_chts

Search took 7 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 Limit1340271555.95322514.2
3Display Results1551550.0602583.3
 (SQL Overall)1786911556.41927837.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.