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

136 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
apod7812318(None) 
aped78538151aped
apo511142121apo_
apods86316341apods
apos65433821apos
pod66351481_pod
abed79734132abed
abo59045962abo_
abode85518812abode
abos67734412abos
aced79540882aced
acid77533392acid
acold86214932acold
ad311975032a__d
add510132362a_dd
ado49146872ado_
ados57633512ados
aeon45634612aeon
aged67334252aged
ago48845522ago_
agog68019002agog
agon56531882agon
ahed89536252ahed
ahold94714252ahold
ahoy101919182ahoy
aid49269082a_id
allod64418382allod
aloe45540192aloe
aloud65018072aloud
alow75328592alow
amid77036352amid
amok10217402amok
amped104820512amped
and47244172a_nd
anoa45634472anoa
anode65021042anode
anon46134852anon
ape57251182ap_e
aper66336232aper
apes66047432apes
apex137220212apex
aphid115515392aphid
apodal9289832apodal
aport75432172aport
app76827602ap_p
apps86319692apps
apron7318832apron
apse67725382apse
apt57352542ap_t
arid57642712arid
aroid65428342aroid
atom67824522atom
atop66124752atop
auld54125362auld
avid88325962avid
avo68936232avo_
avoid95516682avoid
avos77227012avos
avow107816462avow
awed88436032awed
awol75620672awol
axed128829612axed
axon115524302axon
azo128233392azo_
azon135725052azon
bipod104410822bipod
bod67055542_bod
caped104931802caped
capo85829212capo_
capon95221872capon
capos94826072capos
clod76124612clod
cod69660122_cod
ephod1139122ephod
epode85114092epode
epos66723732epos
feod815523002feod
food86830572food
gaped96123532gaped
god57449792_god
good66531802good
hod76852462_hod
hood85132332hood
japed156217632japed
kapok10448782kapok
mod69054402_mod
mood76332062mood
nod47549562_nod
od39255242__od
oped76230152oped
pad68057322_pad
pagod95013682pagod
paid75737482paid
pard76441322pard
ped66751522_ped
plod76723272plod
pods76540152_pods
poh86740532_poh
poi57244662_poi
pol56449382_pol
pom78249912_pom
pond75530492_pond
poo57757112_poo
pood75934322pood
pop76252252_pop
pot58078432_pot
pow87147282_pow
pox126140692_pox
prod76129502prod
pud65836652_pud
quod145413622quod
raped85334622raped
rapid86422032rapid
rod47953892_rod
rood56733002rood
sapid84720932sapid
sapor75119252sapor
sarod65325872sarod
shod86225062shod
sod46053702_sod
sped76031492sped
spode84617702spode
spot65540692spot
spud75818492spud
taped85327422taped
tod49457072_tod
trod57627952trod
updo76712882updo
upo58925862upo_
upon65817582upon
vapid115614282vapid
vapor104013092vapor
wood85329382wood
yapok14468152yapok
yapon104613582yapon
yod77545502_yod

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 Filter178691298720.280638182.1
2DLD Change Limit298721360.95331345.2
3Display Results1361360.0334121.2
 (SQL Overall)1786911361.266141146.1
 
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.