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 “poniards” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 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
poniards114582(None) 
poniard1037581poniard_
goliards1045132goliards
laniards967312laniards
onwards1137172_onwards
pochards1646852pochards
pollards11299522pollards
poniarded1343162poniarded
poulards11288232poulards
boards94616933bo__ards
bollards11339153bollards
bombards1536493bombards
boneyards1584623boneyards
boniatos1046673boniatos
boyards13399323bo_yards
briards10398553_briards
canards10311203can_ards
collards113310193collards
concords1358593concords
costards113510793costards
cowards1339613co_wards
dotards937253do_tards
downwards1743833downwards
forwards1537043forwards
foulards12266463foulards
goliard936073goliard_
gonads84511733gon_a_ds
hoards104912623ho__ards
holards1148433ho_lards
innards837153_innards
inwards1138343_inwards
laniard868523laniard_
lanyards1266393lanyards
liards75212613__liards
mansards1148013mansards
manwards1447613manwards
monads94515303mon_a_ds
monarda1046613mon_arda
monardas1145713mon_ardas
moonwards1574203moonwards
nards65928463__n_ards
nonarts7311303non_arts
nonhardy1544333nonhardy
nonwars10109003nonwar_s
nonwords1247463nonwords
onward1039053_onward_
paniers94717333panier_s
pards85634333p___ards
pentads1039523penta_ds
petards104311153p_etards
placards1345813placards
pleiads1045223pleia_ds
pochard1537363pochard_
poinds93511143po_i_nds
polars84419353po_lar_s
pollard103511143pollard_
ponders103618843ponder_s
ponds85323403pon___ds
pongids11347413pon_gids
poniarding1443363poniarding
ponied94920703poni_ed_
ponies84833463poni__es
poplars113910333poplar_s
postcards1445733postcards
potshards1544053potshards
poulard10299733poulard_
poularde11276573poularde
poulardes12286183poulardes
sonars64818973son_ar_s
sunwards1236443sunwards
tankards1366253tankards
tanyards1276183tanyards
tonearms1044713tonearms
towards1138783to_wards
unitards945623_unitards

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 Filter1786911461620.420425454.8
2DLD Change Limit146162757.47019566.5
3Display Results75750.0302500.0
 (SQL Overall)178691757.92022562.0
 
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.