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

118 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
poniard103758(None) 
poniards1145821poniards
goliard936072goliard
laniard868522laniard
onward1039052_onward
pochard1537362pochard
pollard103511142pollard
poniarded1343162poniarded
ponied94920702poni_ed
poulard10299732poulard
board85523003bo__ard
bollard103210503bollard
bombard1437333bombard
boneyard1475323boneyard
boniato947283boniato
bonier84321993bonier_
boyard125411283bo_yard
briard94311293_briard
canard9314763can_ard
collard103712923collard
concord12510343concord
congaed11399743congaed
costard104113353costard
coward12411673co_ward
donnerd9427813donnerd
dotard839053do_tard
downward1644443downward
eonian6311833eonia_n
foliar93210973foliar_
forward1438293forward
foulard11257283foulard
goliards1045133goliards
gonad75216053gon_a_d
gonia64117533gonia__
hoard94918313ho__ard
holard10410573ho_lard
honied104818393honi_ed
inward10310333_inward
ionised82911493ionised
ionized172611293ionized
laniards967313laniards
laniary1068013laniary
lanyard1167293lanyard
liard65418593__liard
mansard1049313mansard
manward1349093manward
monad85519473mon_a_d
monarda1046613mon_arda
monied94319463moni_ed
moonward1474473moonward
nard56634453__n_ard
nonart6319193non_art
nonfarm1246513nonfarm
nonhardy1544333nonhardy
nonpaid1048073nonpaid
nonpar8168993nonpar_
nonwar9159423nonwar_
nonwars10109003nonwars
nonword1149153nonword
onboard1046503_onboard
onwards1137173_onwards
panier84425503panier_
paniers94717333paniers
pard76441323p___ard
penial84120893penia_l
pentad9313763penta_d
petard95013803p_etard
phonied133710563phoni_ed
phonier122710633phonier_
pinier84024693pinier_
placard1236783placard
pleiad947833pleia_d
pochards1646853pochards
podia8415283podia__
podiatry1444353podiatry
poind84217913po_i_nd
poinded11358973poinded
pointed103813983pointed
poised94918473po_ised
pokier124914633pokier_
polar75623453po_lar_
polars84419353po_lars
poleward1455943poleward
policed123212233policed
polkaed1435323polkaed
pollards11299523pollards
ponced114314813pon_ced
pond75530493pon___d
ponded105218773pon_ded
ponder94521693ponder_
pondered126411293pondered
ponders103618843ponders
ponged105619353pon_ged
pongid104111583pon_gid
poniarding1443363poniarding
ponies84833463poni_es
poplar103611113poplar_
poplars113910333poplars
pornier93413133pornier_
posited10511493posited
postcard1346523postcard
potshard1444533potshard
poularde11276573poularde
poulards11288233poulards
poxier153812113poxier_
punier84519223punier_
sonar56523423son_ar_
sonars64818973son_ars
sunward1137653sunward
tankard1267263tankard
tanyard1167183tanyard
tonearm937443tonearm
tonier65520713tonier_
topiary1245813topiary
toward10311063to_ward
unitard838003_unitard
vanward1456943vanward
zonary1838793zon_ary

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.393454684.5
2DLD Change Limit1340271186.57620381.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.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.