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

151 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
outchid133872(None) 
outchide1447211outchide
hutched16359882hutched
orchid1289572o_rchid
ouched124316932ou_ched
outbid91411862out_bid
outchided1645172outchided
outchides1546792outchides
outcried1139542outcried
outdid81210922out_did
outhit92818472out_hit
outlaid81110652outlaid
outsaid81210922outsaid
autacoid1146253autacoid
autocoid1147643autocoid
batched154114243batched
bitched153212923bitched
botched153611903botched
bunched154312413bunched
butch125416543butch__
butcher143411163butcher
butches144315363butches
chid106626403___chid
clutched16356033clutched
couched154115793cou_ched
couthie121810553cout_hie
crutched16307463crutched
cutch125116193cutch__
cutches143216463cutches
ditched143711903ditched
douched144012113dou_ched
dutch114713823dutch__
etched123613703_etched
fetched163710473fetched
fucoid1237893fu_coid
glochid1445263glochid
grutched15284673grutched
hatched163414463hatched
hitched163312253hitched
hotched163610923hotched
hunched163710493hunched
hutch135414093hutch__
hutches153613523hutches
hutching17318643hutching
itched123812023_itched
latched133914063latched
letched133912053letched
litchi1137893litchi_
litchis1238373litchis
lucid84314573lu_c_id
lunched133911823lunched
lurched13358033lurched
matched153513963matched
mouched153612593mou_ched
mouthed133811043mout_hed
mucid104115253mu_c_id
mucoid1139783mu_coid
mulched15307763mulched
munched153411073munched
muscid11219833musc_id
mutch125016173mutch__
mutches143314283mutches
mutchkin1943023mutchkin
nitchie1247233nitchie
notched134210303notched
ootid61416703oot__id
orchids1377213o_rchids
orchil1158653o_rchil
orchis11710773o_rchis
osteoid848193osteoid
ouch95724633ou_ch__
ouches114322183ou_ches
ouching134314903ou_ching
outacted1139383outacted
outadd837803out_add
outbids1098913out_bids
outbred10311263outbred
outbuild1144843outbuild
outcall9310123outcall
outcast91013743outcast
outcavil1343833outcavil
outcharm1544733outcharm
outcheat1349413outcheat
outchidden1751653outchidden
outchiding1745183outchiding
outcity1238453outcity
outclimb1442963outclimb
outcome11310573outcome
outcook1337203outcook
outcries10313573outcries
outcrop1146773outcrop
outcrow1246343outcrow
outcrowd1444933outcrowd
outcry1137993outc_ry
outecho1244893outech_o
outechoed1544633outechoed
outed65429063out__ed
outfind1139563outfind
outfit93014953out_fit
outgain81010743outgain
outgrin8810553outgrin
outguide1045953outguide
outhits102213503out_hits
outlain71212613outlain
outland81212343outland
outlead83311103outlead
outled74020343out_led
outlie62419533out_lie
outplod10106343outplod
outread82811093outread
outride82615683out_ride
outrig72812853out_rig
outsail71411413outsail
outscold11115253outscold
outshine11310723outshine
outshined1346543outshined
outshot10312103outshot
outside82414193out_side
outsin63617563out_sin
outsit63620893out_sit
outsold8109073outsold
outsped101110323outsped
outswim1244843outswim
outthink1545583outthink
outtold8107603outtold
outvie92412803out_vie
outvied11239693outvied
outwait10411763outwait
outward11811403outward
outwhirl1443183outwhirl
outwind1139153outwind
outwit93014593out_wit
outwrit10411423outwrit
patched153514623patched
pitched153512923pitched
pouched153612773pou_ched
punched153512173punched
putrid9311173put_rid
retched133814273retched
ruched124314633ru_ched
scutched16186893scutched
smutched16165923smutched
southed114313993sout_hed
sulphid1346113sulphid
tetched133010773tetched
touched134914963tou_ched
unchic1338643_unchic
urchin1138743_urchin
vouched163910563vou_ched
watched163012823watched
witched163012193witched

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.390458182.1
2DLD Change Limit1340271516.70319995.1
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.15624970.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.