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

180 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
potiche143804(None) 
postiche1547791postiche
potiches1539201potiches
notice8313442notic_e
pastiche1546932pastiche
police102918562polic_e
postiches1648222postiches
potlache15114282potlache
rotche114311982rot_che
affiche1844313affiche
article9310923article
attache12106693attache
babiche1644573babiche
bobeche1643843bobeche
boche124216953bo__che
bodice11711423bodic_e
botch126717453bot_ch_
botched153611903bot_ched
botcher143613223bot_cher
botches143716023bot_ches
botchy16537823bot_chy
caliche14329953caliche
ceviche1744143ceviche
cliche133712453_cliche
corniche1575923corniche
cuticle1138233cuticle
douche124613223do_uche
entice81316863entic_e
fetich1479693fetich_
fetiches1636953fetiches
fiche134616743__fiche
gotcha1234633got_cha
gouache1335033gouache
hotch136214733hot_ch_
hotched163610923hot_ched
hotches153814363hot_ches
loricae938253loricae
lotic76420673lotic__
louche115212663lo_uche
mastiche1547173mastiche
miche126219243__miche
mortice11711493mortic_e
motile83818343moti_le
motive113112143moti_ve
niche105016793__niche
notch105613323not_ch_
notched134210303not_ched
notcher123610933not_cher
notches123513653not_ches
noticed1037863noticed
noticer937273noticer
notices9312283notices
novice1138433novic_e
optic93715183optic__
optical1149863optical
optics102810183optic_s
optime1079353opti_me
orache114013593_orache
otic66624823_otic__
otiose639403_otiose
panache1458423panache
panicle11129983panicle
panoche1456383panoche
particle1239533particle
pastiches1637453pastiches
patch125221223pat_ch_
patched153514623pat_ched
patcher143515143pat_cher
patches143320383pat_ches
patchy16509573pat_chy
patinae95414403patinae
patine85328123pati_ne
pedicle1238973pedicle
penoche1447043penoche
penuche1435943penuche
petiole9311303petiole
petite84320653peti_te
photic133316443photic__
photics142810483photic_s
pice84641093p__ic_e
pistache1545893pistache
pitch125018413pit_ch_
pitched153512923pit_ched
pitcher143813713pit_cher
pitches143617753pit_ches
pitchy16479673pit_chy
plaice10311553plaic_e
planche14299753planche
plicae10410953p_licae
poach124917863po_ach_
poached154212403po_ached
poacher143912323po_acher
poaches144416943po_aches
poachy16388963po_achy
podite93315353podi_te
poetic10416843poetic__
poetical12311533poetical
poeticize2247523poeticize
poetics11312073poetic_s
poetise9314043poeti_se
poetize18310773poeti_ze
pointe84619313po_inte
poise75127893po_i_se
poisha1135723po_isha
policed123212233policed
policer113112683policer
polices113118053polices
policies122415663policies
policy133211513polic_y
polish114916723polish_
polished1468433polished
polisher1388073polisher
polishes13711783polishes
polite83625073poli_te
pomace123111913pomac_e
ponce95222513po_nc_e
poncho133310123po_ncho
pontine92419053ponti_ne
pooch124815303po_och_
pooched152810083po_oched
pooches143214163po_oches
popish133812113popish_
popsicle1443653popsicle
porch125918623po_rch_
porches143815673po_rches
porcine11312843porcine
portico11310143portic_o
porticoed1445423porticoed
porticoes1348253porticoes
porticos1238373porticos
portiere1038773portiere
postie84123963posti__e
postique1945873postique
potable112115363potable
potage92715903pot_age
potash1138273potash_
potashes1337833potashes
potence11711363potence
pother113818853pot__her
pothole12312173pothole
potion84519573poti_on
potions93417423potions
potlach14106363potlach_
potlaches16115263potlaches
potlike13910123potlike
potline91015233potline
potpie103412433pot_pie
potsie83916033pot_sie
pottage103310603pottage
pottle84416103pot_tle
pouch124617083po_uch_
pouched153612773po_uched
pouches144116743po_uches
pouchy16538663po_uchy
poultice1246063poultic_e
pounce105214093pounc_e
poutine93316823pouti_ne
price93725413p_ric_e
psyche1674293p_syche
ptotic102713373ptotic__
pumice1238223pumic_e
putsch1334933putsch_
putsches1535313putsches
quiche2057903_quiche
reticle94112623reticle
rotch105815933rot_ch_
rotches123515703rot_ches
rouche114714313ro_uche
seiche11811833_seiche
seviche1545113seviche
soroche1237183soroche
soutache1344983soutache
stich104117923_stich_
stichs114511653_stichs
tache106222373__tache
tithe85319703__tithe
touche114916173to_uche
voice104915323vo_ic_e
vomicae1445303vomicae
votive12348933voti_ve

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 Limit1340271806.54620474.6
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.01525472.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.