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

237 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
potiches153920(None) 
postiches1648221postiches
potiche1438041potiche_
botches143716022bot_ches
fetiches1636952fetiches
hotches153814362hot_ches
notches123513652not_ches
notices9312282notic_es
pastiches1637452pastiches
patches143320382pat_ches
pitches143617752pit_ches
poaches144416942po_aches
polices113118052polic_es
policies122415662policies
polishes13711782polishes
pooches143214162po_oches
porches143815672po_rches
porticoes1348252porticoes
postiche1547792postiche_
potashes1337822potashes
potlaches16115262potlaches
pouches144116742po_uches
putsches1535312putsches
rotches123515702rot_ches
affiches1945233affiches
aitches123014363ait_ches
articles10310243articles
attaches13137723attaches
babiches1735253babiches
batches144019613bat_ches
bitches144117063bit_ches
blotches1537433blot_ches
bobeches1744483bobeches
boches134618523bo__ches
bodices12710593bodic_es
borsches1536003borsches
botched153611903bot_ched
botcher143613223bot_cher
botchers153511543bot_chers
britches15278683britches
butches144315363but_ches
caliches153812263caliches
catches144320763cat_ches
ceviches1834843ceviches
cliches144213743_cliches
coaches144018693co_aches
codices12512583codic_es
conches144019813co_nches
cooches143515833co_oches
corniches1666673corniches
cortices12615003cortic_es
couches144020463co_uches
crotches153411293crot_ches
cutches143216453cut_ches
cuticles1237893cuticles
detaches1439653detaches
ditches133215713dit_ches
douches134315233do_uches
enriches1337263enriches
entices91616333entic_es
etches114217763_et_ches
fetches153413893fet_ches
fetishes1437153fetishes
fiches145219533__fiches
fitches153516193fit_ches
flitches16388463flitches
glitches14296653glitches
gotchas1334613got_chas
gouaches1436193gouaches
hatches153420273hat_ches
hitches153616273hit_ches
hooches153812523ho_oches
hootches1656973hootches
hotched163610923hot_ched
hutches153613523hut_ches
itches114916213_it_ches
ketches164012193ket_ches
kitsches1734073kitsches
latches123320123lat_ches
latices9313763latic_es
letches124015483let_ches
liches114724293__liches
loaches123613983lo_aches
mastiches1647333mastiches
matches143219783mat_ches
miches134320733__miches
monishes13311483monishes
mooches143714453mo_oches
mortices12711553mortic_es
motiles93317433moti_les
motives123611893moti_ves
mouches143815963mo_uches
mutches143314283mut_ches
niches114419143__niches
notched134210303not_ched
notcher123610933not_cher
notchers13279423not_chers
notice8313443notic_e_
noticed1037863notic_ed
noticer937273notic_er
noticers1035693noticers
notifies11310423notifies
novices1238223novic_es
optics102810183optic__s
optimes1148463opti_mes
oraches124216473_oraches
ostriches1446633ostriches
ouches114322183_o_uches
painches1588913painches
panaches15310283panaches
panicles121010113panicles
panoches1548123panoches
parches143720003p_arches
parishes13314753parishes
particles1339803particles
pastiche1546933pastiche_
patched153514623pat_ched
patcher143515143pat_cher
patchers153413303pat_chers
patines95225763pati_nes
paunches1568173paunches
peaches144120053p_eaches
pedicles1338683pedicles
penoches1538933penoches
penuches1536943penuches
perches143717953p_erches
perishes13313753perishes
petioles10311643petioles
petites93820203peti_tes
photics142810473photic__s
pinches144117933p_inches
pishes114722103p__ishes
pistaches1646673pistaches
pitched153512923pit_ched
pitcher143813713pit_cher
pitchers153211483pit_chers
pities83828083piti__es
plaices11411143plaic_es
planches153111863planches
pleaches153210433pleaches
plenches153110623plenches
poached154212403po_ached
poacher143912323po_acher
poachers152910763po_achers
podites103014733podi_tes
poeticizes2347123poeticizes
poetics11312073poetic__s
poetises10313953poeti_ses
poetizes19310253poeti_zes
pogies94123543pogi__es
pointes93216753po_intes
poises84226543po_i_ses
pokies125921333poki__es
police102918563polic_e_
policed123212233polic_ed
policer113112683polic_er
policers12259993policers
polies84034583poli__es
polished1468433polished
polisher1388073polisher
polishers1477603polishers
politicoes14265013politicoes
polities102722343polities
pollices12410753pollic_es
pomaces132712123pomac_es
ponces104720843po_nc_es
ponchos143410703po_nchos
ponies84833463poni__es
pooched152810083po_oched
popsicles1543663popsicles
porticoed1445423porticoed
porticos1238373portic_os
portieres1138203portieres
posies84431433posi__es
posties93128813posti__es
postiques2045833postiques
potables12179703potables
potages102416423pot_ages
potatoes1039943potatoes
potences12710693potences
potencies1369303potencies
pother113818853pot__her
pothers123818623pot__hers
potholes13312933potholes
pothos114214693pot__hos
potions93417423poti_ons
potlache15114283potlache_
potlatches17113323potlatches
potlines10714213potlines
potpies113116173pot_pies
potsies93019483pot_sies
pottages112910453pottages
potties93723543pot_ties
pottles93816983pot_tles
pouched153612773po_uched
poultices1345673poultic_es
pounces114113893pounc_es
poutines102415103pouti_nes
preaches153214893preaches
prices104524543p_ric_es
psyches1755803p_syches
pumices1338273pumic_es
punches144816133p_unches
punishes1338113punishes
quaiches2235343quaiches
quiches2139333_quiches
quitches2236193quitches
ratches123620463rat_ches
retches123318513ret_ches
reticles103912483reticles
riches115022083__riches
roaches123616213ro_aches
rotche114311983rot_che_
rouches124217893ro_uches
scotches15179473scot_ches
seiches12513813_seiches
seviches1635803seviches
snitches13148983snitches
soroches1338803soroches
soutaches1446443soutaches
splotches1643913splot_ches
stichs114511653_stich_s
stitches131410593_stitches
switches16159133switches
taches114224173__taches
tithes94720213__tithes
torches123715433to_rches
touches125118343to_uches
twitches16156373twitches
vetches153411263vet_ches
voices114414013vo_ic_es
vortices1369123vortic_es
votives13337953voti_ves
vouches153914113vo_uches
watches153017373wat_ches
wiches144418753__wiches
witches152715793wit_ches

Search took 9 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.1731032896.0
2DLD Change Limit1461622377.75018859.6
3Display Results2372370.0932548.4
 (SQL Overall)1786912378.01622291.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.