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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
apods8631634(None) 
apod78123181apod_
apos65433821apo_s
pods76540151_pods
abode85518812abode
abodes94417512abodes
abos67734412abo_s
acids87121002acids
adds67622452a_dds
ados57633512ado_s
ads49755732a__ds
aeons57624652aeons
agons66423782agons
aholds10469482aholds
aids57846352a_ids
allods73615082allods
aloes54933672aloes
amids85627512amids
amoks11413552amoks
ands57833612a_nds
anoas57226492anoas
anode65021042anode
anodes74418762anodes
aped78538152aped_
apers76629132apers
apes66047432ap_es
aphids125110842aphids
aphis105917132aphis
apo511142122apo__
apodal9289832apodal
apodous1037402apodous
aport75432172aport
apps86319692ap_ps
apres75426402apres
aprons8316992aprons
apses76823912apses
apsis75718292apsis
aroids75118222aroids
atoms76817562atoms
avoids104410202avoids
avos77227012avo_s
avows114910982avows
awols84713522awols
axons125517932axons
azons146518252azons
bipods11408592bipods
bods76244712_bods
capons104119502capons
capos94826072capo_s
clods85320862clods
cods76848102_cods
ephods1238362ephods
epode85114092epode
epodes94315562epodes
epos66723732epo_s
feods99516852feods
foods95924162foods
gods65438042_gods
goods75124482goods
hods87239862_hods
hoods95124082hoods
kapoks11347262kapoks
mods77945052_mods
moods85224622moods
nods55838222_nods
ods47546212__ods
pads76742952_pads
pagods105310192pagods
pards85634332pards
peds75835242_peds
plods85719292plods
pod66351482_pod_
pois66539042_pois
pols66044562_pols
poms87037742_poms
ponds85323402_ponds
pons65850602_pons
poods85124752poods
poos65949112_poos
pops86340952_pops
pots66452362_pots
pows95537662_pows
prods85523552prods
puds75630512_puds
quods154610222quods
rapids94913892rapids
rods56442062_rods
roods65125282roods
sapors84118812sapors
sarods74918572sarods
sods54940212_sods
spode84617702spode
spodes94817432spodes
spots74424112spots
spuds85113672spuds
tods56141842_tods
updos8389512updos
vapors113812692vapors
woods95723032woods
yapoks15346782yapoks
yapons114411772yapons
yods86531182_yods

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001021.56334421.0
3Display Results1021020.0333090.9
 (SQL Overall)1786911021.90693751.8
 
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.