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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
aroid6542834(None) 
arid57642711ar_id
aroids75118221aroids
avoid95516681avoid
droid74218541droid
aboil72217542aboil
abroad9310942abroad
acaroid103512312acaroid
acid77533392a_cid
acold86214932acold
acrid86920102acrid
adroit7518792adroit
afraid1049722afraid
ahold94714252ahold
aid49269082a__id
alcid85817972alcid
algid75415582algid
algoid83011472algoid
aloin55227422aloin
aloud65018072aloud
ambroid1238882ambroid
amid77036352a_mid
android9311512android
aneroid8314002aneroid
aphid115515392aphid
apod78123182apo_d
aramid93315612aramid
arced88224162arced
areic73219392areic
argil65116882argil
aria46245422ar_ia
aril45843022ar_il
armed86324432armed
aroint6328152aroint
aroma71220142aroma
arose55832082arose
around72712412around
arris56824682arris
arsis55722422arsis
avid88325962a_vid
avoids104410202avoids
azoic162912062azoic
braid85822262braid
broad84817692broad
broil74918222broil
bromid112612892bromid
brood84620242brood
carotid102014832carotid
crowd115815622crowd
droids84712582droids
droit65127122droit
druid74111322druid
frond95316342frond
gadoid9310462gadoid
ganoid8314442ganoid
geoid74215762geoid
grid65829612gr_id
groin65521082groin
haloid104317762haloid
hyoid12612442hyoid
irid55927172ir_id
labroid1038822labroid
loid55531492_loid
myoid11512992myoid
oroide7311702oroide
ovoid94811022ovoid
parotid102915512parotid
prod76129502pro_d
proud84615482proud
pyoid11513762pyoid
rabid84520782rabid
raid55243072_raid
ranid66429332ranid
rapid86422032rapid
rid46754632_r_id
road56332112_road
rod47953892_ro_d
roil46235292_roil
rood56733002_rood
sarcoid10310452sarcoid
sarod65325872saro_d
sloid64619712sloid
sparoid102311542sparoid
toroid7416012toroid
trod57627952tro_d
trois57226092trois
ursid6311482ursid
viroid10411522viroid
void86220562_void
zooid15312102zooid

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.313570897.8
2DLD Change Limit53800901.59333772.8
3Display Results90900.0165625.0
 (SQL Overall)178691901.92292971.4
 
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.