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

169 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
poulard1029973(None) 
foulard11257281foulard
pollard103511141pollard
poularde11276571poularde
poulards11288231poulards
bollard103210502bollard
collard103712922collard
foulards12266462foulards
holard10410572ho_lard
pochard1537362pochard
polar75623452po_lar_
polars84419352po_lars
pollards11299522pollards
poniard1037582poniard
poplar103611112poplar_
poplars113910332poplars
popular11319562popular_
poulardes12286182poulardes
poultry1235382poultry
alular6311353alular_
aoudad835033aouda_d
board85523003bo__ard
bolar75123473bo_lar_
bollards11339153bollards
bombard1437333bombard
boulevard1552233boulevard
boyard125411283bo_yard
coalyard1444083coalyard
collar83816173collar_
collards113310193collards
collared113211143collared
collars93816573collars
copular113810603copular_
costard104113353costard
cougar958783cougar_
cougars1038423cougars
could86517713coul__d
coward12411673co_ward
dollar74110983dollar_
dollars83311023dollars
dotard839053do_tard
doula65717773doula__
doulas75114993doula_s
dullard936603dullard
forward1438293forward
fouled104315973foul_ed
fouler93614903fouler_
goalward1343493goalward
goliard936073goliard
goulash1164273goulash
gourd71011903gou__rd
guard74415543_gu_ard
gular6314833_gular_
haulyard1583223haulyard
hoard94918313ho__ard
holards1148433ho_lards
hollaed11359853hollaed
holland11349473holland
jocular1637303jocular_
lard56742003___lard
lobular936663lobular_
locular938953locular_
lowland1134693lowland
mallard10310273mallard
modular1087363modular_
modulars1165833modulars
molar75223093mo_lar_
molars85517323mo_lars
morular978223morular_
moulage1037903moulage
mould86015753moul__d
moulded11348063moulded
moulted103310313moulted
nodular876703nodular_
norland837163norland
ocular8610133ocular_
oculars948363oculars
onward1039053_onward
ourari63413543_ourari
outadd837803_outadd
outlaid81110653_outlaid
outland81212343_outland
outward11811403_outward
ovular946833ovular_
ovulary1344913ovulary
pabular11259473pabular_
paillard1146263paillard
papular11299763papular_
pard76441323p___ard
pedlar93311273pedlar_
pedlars103210213pedlars
pedlary13277543pedlary
petard95013803p_etard
phylar14437373phylar_
pilar75221503p_ilar_
pillar8314023pillar_
pillared11228083pillared
pillars9313483pillars
pilular938203pilular_
placard1236783placard
plaid85118303p__laid
plowland1442743plowland
poblano1145093poblano
pochards1646853pochards
polaron939843po_laron
poled84934843po_l_ed
poler74431793po_ler_
polers84225643po_lers
poleward1455943poleward
polkaed1435323polkaed
pollack1567333pollack
pollarded1344703pollarded
polled94022003po_lled
poller83921853poller_
pollers93420023pollers
poniards1145823poniards
pooled94619813pool_ed
pooler83819843pooler_
poolers94217423poolers
populace14256253populace
popularly1663843popularly
populate122812093populate
populated14228803populated
postcard1346523postcard
potlach14106363potlach
potshard1444533potshard
pouched153612773pouched
poufed12449713pou_fed
pouffed16365953pouffed
poult76928873poul__t
poulter93712013poulter
poulters103911043poulters
poults84613483poul_ts
pounced123510623pounced
pound84417863pou__nd
pounded114112793pounded
pour611527473pou__r_
poured95116743pou_red
pourer84516043pourer_
pourers93513673pourers
pours74623183pou__rs
pouted94021393pou_ted
pouter83923983pouter_
pouters94221863pouters
pula65129373p_ula__
puled84926523p_ul_ed
puler74826623p_uler_
pulers83820283p_ulers
pulled94322193p_ulled
pulped114612533p_ulped
pulsar8329363p_ulsar_
pulsars9358913p_ulsars
pulsed94013723p_ulsed
roulade856993roulade
soland75115043so_land
solar55927343so_lar_
souari6311373sou_ari
soucar839323soucar_
soucars938413soucars
souled75419823soul_ed
sporular1065223sporular_
tolar55524113to_lar_
tolars64817923to_lars
toward10311063to_ward
uvular955563uvular_
uvulars1044413uvulars
volar86917413vo_lar_
would95513153woul__d
zonular1656493zonular_

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 Limit1340271696.46620728.0
3Display Results1691690.0632682.5
 (SQL Overall)1786911696.68526730.1
 
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.