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

88 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
placards134581(None) 
placard1236781placard_
flancards1543182flancards
placarded1543252placarded
placates12311752placates
placers114515262placer_s
placoids1347342placoids
acarids105312243__acarids
acarus8312193__acarus
awards107113453__awards
bayards13379683_bayards
calcars11312653calcar_s
canards10311203_canards
cards85137933___cards
clochards1743823clochards
discards1238913discards
filmcards1742473filmcards
flancard1443373flancard_
flashcards1951853flashcards
flatcars1344623flatcar_s
halyards1576243halyards
hazards2037463_hazards
keycards1843063keycards
lacers85225253_lacer_s
laggards11307053_laggards
lahars94013163_lahar_s
lairds74711613_la_irds
laniards967313_laniards
lanyards1266393_lanyards
lards65331863_l__ards
lascars979013_lascar_s
lazars153812393_lazar_s
liards75212613_l_iards
lizards17427613_lizards
mallards1138323mallards
mazards1937703_mazards
pacas96029403p_aca__s
pacers105124543p_acer_s
pards85634333p___ards
petards104311153p_etards
picaras11311283p_icaras
picaros11310893p_icaros
pilchards1743923pilchards
placable14169243placable
placably17156673placably
placarding1643413placarding
placate11312433placa_te
placated1338453placated
placater1238013placater
placaters1336473placaters
placebos1443713placebos
placed114318003plac_ed_
placer105117743placer__
places104323703plac__es
placets113911223plac_ets
placid114012543plac_id_
plackets1646583plackets
placks144414153plac__ks
placoid1239773placoid_
plafonds1443273plafonds
plaids94312443pl__aids
planar84212713planar__
planaria1047353planaria
planarias1147403planarias
planers94517943planer_s
plasmids13236553plasmids
plastids11269213plastids
platanes102711883platanes
platans93413123plata_ns
platers93924093plater_s
playacts1543813playacts
playas114612283playa__s
players124313763player_s
playlands1543893playlands
plazas17409913plaza__s
pleads94613953pl_ea_ds
pleiads1045223pleia_ds
pochards1646853pochards
pollards11299523pollards
poniards1145823poniards
postcards1445733postcards
poulards11288233poulards
procarps1445973procarps
seawards1237203seawards
tabards10310383_tabards
teacarts10116073teacarts
vawards14457573_vawards
wildcards1643043wildcards

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.423422437.4
2DLD Change Limit146162887.50019488.3
3Display Results88880.0332666.7
 (SQL Overall)178691887.95622459.9
 
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.