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

72 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
pleopod124482(None) 
pleopods1344441pleopods
pereopod1344932pereopod
pteropod1344662pteropod
bleeped12287273bleeped
blood85319523bl_o_od
blooped12398543blooped
chenopod1643943chenopod
cleped115114113cle_ped
diplopod1453883dipl_opod
eloped95914143el_oped
endopod1145763endopod
flood95215603fl_o_od
isopod935913_isopod
leaped94317773_leaped
leopard1045293_leopard
looped95217173_looped
loped85128333_l_oped
lycopod1543713lycopod
monopod1247493monopod
octopod1244893octopod
paleosol1043883paleosol
peeped113915393p_eeped
pelecypod1961613pelecypod
peloton938743peloton
people10310193p_eople
peopled1238503p_eopled
pepo87622153p_e_po_
pepos96620083p_e_pos
pepped103113403p_epped
pereiopod1452733pereiopod
pereopods1444233pereopods
period9314983p_eriod
pernod9310453p_ernod
phyllopod2052433phyllopod
plead85818463ple__ad
pleaded113511263pleaded
pleased103712073pleased
pleated103816633pleated
pled75231433ple___d
pledged12358633pledged
pledgor11334993pledgor
pleiad947833ple_iad
pleon74216383ple__on
pleonal937243pleonal
pleonic1139433pleonic
pleons84213343pleo_ns
plessor9317693plessor
pleuron976343pleuron
plexor1535253ple_xor
plod76723273pl___od
plop86625743pl_op__
plopped11288773plopped
plops95920333pl_op_s
plowed124213203pl_owed
ployed124310563pl_oyed
plumped14318643plumped
plywood1645133plywood
polypod1546983polypod
pood75934323p__o_od
pooped113915943p_ooped
preop94715873preop__
preops104911943preop_s
prepped11329903prepped
protopod1347353protopod
pseudopod1552943pseudopod
pteropods1444653pteropods
seedpod1144013seedpod
sloped94216853sl_oped
theropod1445433theropod
upleaped1334333upleaped
uropod937263_uropod

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.390458182.1
2DLD Change Limit134027726.94019312.2
3Display Results72720.0302400.0
 (SQL Overall)178691727.36024278.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.