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

218 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
ponchos14341070(None) 
conchos144313961conchos
honchos15369571honchos
poncho133310121poncho_
anchos114214892_anchos
bronchos15206172bronchos
conchas144013312conchas
conches144019812conches
concho134414262concho_
conchs134714902conch_s
honcho14389382honcho_
pinches144117932pinches
poaches144416942poaches
ponces104720842ponc_es
ponchoed1646132ponchoed
pooches143214162pooches
porches143815672porches
pothos114214692po_thos
pouches144116742pouches
psychos1765262psychos
punches144816132punches
ranchos123911392ranchos
ancho104515303_ancho_
anchor113911973_anchor
anchors123912953_anchors
bancos104713893banc_os
benches143918603benches
benthos1238373benthos
boches134618523bo_ches
bohos105618253bo__hos
bongos95316653bon_gos
bonitos939733bonitos
bonobos1136393bonobos
boocoos1137753boocoos
botches143716023botches
broncho14206463broncho_
bronchus15204743bronchus
broncos11188073bronc_os
bunches144116033bunches
buncos104011593bunc_os
canchas143212403canchas
cinches144215773cinches
coaches144018693coaches
coanchor1545253coanchor
coanchors1645733coanchors
cocos95624693co_c_os
cohos105921853co__hos
conch124620073conch__
concha134213283conch_a
conchae143911643conchae
conchal144211583conchal
conchie143312683conchie
conchies153214853conchies
conchoid1688043conchoid
conchoids1766273conchoids
conchy163710223conch_y
concurs11311473concurs
concuss1138063concuss
condos94322333con_dos
congos94219883con_gos
contos84923233con_tos
cooches143515833cooches
couches144020473couches
douches134315233douches
dunches133312583dunches
echos105216463__echos
epochs1335813epo_ch_s
finches153914193finches
gauchos1345903gauchos
gotchas1334613gotchas
honchoed1745733honchoed
hooches153812523hooches
hotches153814363hotches
hunches153913463hunches
inches114419673_inches
jockos19527563jo_ckos
juncos15449233junc_os
kenches163912273kenches
kolkhos1364013kolkhos
loaches123613983loaches
lochs106715513lo_ch_s
locos75822603lo_c_os
lunches124115443lunches
lynches15378873lynches
machos135217493_machos
manches143818623manches
mochas13310663mo_chas
mondos95217333mon_dos
mongos94318623mon_gos
monos75930863mon__os
months113812933month_s
mooches143714453mooches
morphos14159083morphos
mouches143815963mouches
munches144215793munches
nachos115014183_nachos
nonces84418833nonc_es
noncom1039683nonc_om
noncoms1139203noncoms
nonegos837143nonegos
nonpros937473nonpros
notches123513653notches
nuncios937113nuncios
onos46229003_on__os
orchis11710773_orchis
ouches114322183_ouches
pachas135017143p_achas
painches1588913painches
panaches15310283panaches
panchax2134983panchax
panochas1545653panochas
panoches1548123panoches
pantos85222743pan_tos
parches143720003parches
patches143320383patches
pathos115516693p_athos
paunches1568173paunches
peaches144120053peaches
pechs125516203p_ech_s
pencels113610053pencels
pencils113011773pencils
pengos94612413pen_gos
penoches1538933penoches
penuches1536943penuches
penuchis1544283penuchis
perches143717953perches
phonos114114793phon__os
picachos1744523picachos
pincers113916503pincers
pinch125619303pinch__
pinched153812453pinched
pincher143812713pincher
pinchers153510613pinchers
pingos95317673pin_gos
pinkos125313873pin_kos
pintos86021293pin_tos
piscos105112593pisc_os
pitches143617753pitches
planches153111863planches
plenches153110623plenches
poaceous1267173poaceous
poach124917863poach__
poached154212403poached
poacher143912323poacher
poachers152910763poachers
poachy16388963poach_y
pocks135022963po_c_ks
poco86826153po_c_o_
poechore1547853poechore
poechores1647953poechores
polios84019723po_lios
polos76129913po__los
pomelos11218133pomelos
pomos95321583po__mos
ponce95222513ponc__e
ponced114314813ponc_ed
poncing122913583poncing
ponders103618843ponders
ponds85323403pon__ds
pones74547043pon__es
pongees104212543pongees
pongids11347413pongids
pongs85526343pon__gs
ponies84833463pon_ies
pons65850603pon___s
pontes83627853pon_tes
pontils9312213pontils
ponton83217643pon_ton
pontons93315553pontons
pontoon93010703pontoon
pontoons10279313pontoons
pooch124815303pooch__
pooched152810083pooched
poohs103915713po_oh_s
poos65949113po___os
porch125918623porch__
pornos85015253po_rnos
potiches1539203potiches
potshot1249733potshot
potshots1346283potshots
pottos84615873po_ttos
pouch124617083pouch__
pouched153612773pouched
pouchy16538663pouch_y
pouncers12349203pouncers
pounces114113893pounc_es
prechose15129773prechose
psyches1755803psyches
psycho1674533psycho_
psychs1653653psych_s
punch125118423punch__
punched153512173punched
puncheon1544473puncheon
puncheons1643913puncheons
puncher143311673puncher
punchers152610073punchers
punchy16398523punch_y
puntos85915793pun_tos
ranches123620113ranches
rancho114310853rancho_
rhonchus1642053rhonchus
roaches123616213roaches
rondos74616733ron_dos
rotches123515703rotches
rouches124217893rouches
sorghos11327603sorghos
synchros1645203synchros
synchs14408453synch_s
tenches123515523tenches
tondos75115923ton_dos
torches123715433torches
torchon1237363torchon
torchons1337503torchons
touches125118343touches
uncos74117033_unc_os
vouches153914113vouches
wenches152914133wenches
winches154714373winches

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.1561145455.1
2DLD Change Limit1340272185.93622578.7
3Display Results2182180.0762868.4
 (SQL Overall)1786912186.16828970.7
 
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.