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

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

125 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
adipous103718(None) 
acinous9310932acinous
adieus739632adi_eus
adios65822862adi_o_s
adipose1036652adipose
adiposes1137172adiposes
adiposis1146252adiposis
odious749932odi_ous
acajous1666483acajous
acarpous1245313acarpous
acerous9513333acerous
acetous9410363acetous
acinus8311253aci_nus
adaptors1145253adaptors
adapts9107813adap_ts
adepts9117103adep_ts
adieu6417423adi_eu_
adieux1444283adi_eux
adipic1137263adip_ic
adits66523713adi__ts
adnoun757033ad_noun
adnouns835453ad_nouns
adobos9438453adobo_s
adopts998083adop_ts
ados57633513ad__o_s
aduncous1143163aduncous
advisors12143903advisors
aeneous739893aeneous
agamous1037943agamous
agios65919863agi_o_s
airbus848343a_irbus
alipeds10386793alipeds
aliyos9349533aliyo_s
amadous1038503amadous
amicus103810003ami_cus
amidols10457563amidols
amigos94511213amigo_s
amorous9311133amorous
andirons948423andirons
anginous947643anginous
animus84211613ani_mus
anions64123033ani_ons
anurous7311553anurous
anxious1437283anxious
apodous1037403apodous
apods86316343a__pods
apos65433823a__po_s
aqueous1636053aqueous
arduous837613arduous
arenous7314183arenous
audios72312283audi_o_s
auditors947613auditors
aurous64119263a_urous
avions94114393avi_ons
avisos95410483aviso_s
awmous1157713a_wmous
axioms15408053axi_oms
axions134713483axi_ons
azygous2043123azygous
bijous1548043_bijous
bipods11408593_bipods
caducous1344383caducous
caribous1258823caribous
carious93320283cari_ous
copious11311963copious
coypous14248813coypous
daikons12186693daikons
daimons10249323daimons
depots94716343_depots
dicots94915793_dicots
didoes85716963_didoes
didos76820813_dido_s
dimout9414243_dimout
dimouts1037893_dimouts
dingus83611843_dingus
dinos65428063_dino_s
diols65521013_di_ols
diploes101111493_diploes
dipody1336363_dipody
dipole91112853_dipole
dipoles101013753_dipoles
dips75536913_dip__s
dipsas9359893_dipsas
dipsos95310053_dipsos
discus94512113_discus
divots104712203_divots
editors839423editors
galipots1145213galipots
gipons9389603_gipons
heinous1038853heinous
hideous1168433hideous
idioms956413idi_oms
idiots768643idi_ots
impious1137063impious
ladinos8389963ladino_s
laminous1037953laminous
lupous849433_lupous
manitous1039173manitous
miaous8511693_miaous
odorous837663odorous
ominous949033ominous
pappous1057463pappous
pilous84717753_pilous
pious74621273_pi_ous
pompous1338063pompous
pulpous1177013pulpous
quippus20363543quippus
quipus17458003quip_us
radios74018673radi_o_s
radius73914873radi__us
rimous8311913_rimous
ruinous739763ruinous
sadirons936023sadirons
sanious7514103sani_ous
slipout949083slipout
slipouts1044893slipouts
spinous9310443spinous
talipots1045623talipots
tedious838443tedi_ous
tripods10359053tripods
tripos84014923tripo_s
unipods1095703unipods
urinous7310083urinous
various103113103vari_ous
vinous93914173_vinous

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 Limit1340271257.03019065.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.46623934.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.