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

138 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
voids9541468(None) 
avoids104410201avoids
loids66220711loids
ovoids10456921ovoids
vids85627551v_ids
void86220571void_
acids87121012acids
aids57846372_aids
amids85627522amids
aroids75118222aroids
avoid95516682avoid_
bids75838462_bids
bods76244722bo_ds
boils75427192boils
bolds85825282bolds
bonds86126842bonds
bovids1287972bovids
caids85226432caids
cods76848112co_ds
coeds85920162coeds
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
colds85726972colds
cords86030622cords
doits66223672doits
droids84712582droids
fids87034752_fids
foils85025812foils
foins85523382foins
folds95221692folds
fonds95824822fonds
foods95924162foods
fords95328182fords
geoids8369842geoids
gids65933752_gids
goads77022852goads
gods65438052go_ds
golds75421312golds
goods75124482goods
gowds105814042gowds
grids75321402grids
guids75516162guids
hods87239872ho_ds
holds94623242holds
hoods95124082hoods
hyoids1377672hyoids
ids47535482__ids
imids86015152imids
iodids83711152iodids
irids66417782irids
joins125818412joins
kids96029652_kids
kois85129412koi_s
lids56336472_lids
loads65323372loads
loid55531502loid_
loins56728422loins
lords64923502lords
maids86327152maids
mids76541802_mids
mods77945062mo_ds
moils76125752moils
molds85324832molds
moods85224622moods
nods55838232no_ds
noils55024332noils
noirs55615462noirs
odds68919932_odds
ods47546222_o_ds
oils46337982_oils
olds55926582_olds
ootids71110352ootids
ouds56430112_ouds
ovoid94811022ovoid_
oxids13128972oxids
pods76540162po_ds
poinds93511142poinds
pois66539042poi_s
ponds85323402ponds
poods85124752poods
qaids156116322qaids
quids154917472quids
raids65827522raids
rids56539562_rids
roads66523622roads
rods56442072ro_ds
roils54826792roils
roods65125282roods
saids65328862saids
skids104615342skids
sloids73712692sloids
sods54940222so_ds
soils55327982soils
solids74116402solids
sords64527802sords
toads65621072toads
tods56141852to_ds
toils54527492toils
toits55327472toits
vails85825932vails
vairs85019132vairs
veils84918802veils
veins84620492veins
velds95615582velds
vends95520892vends
vid77241822v_id_
vide85432772v_ide
vies75238632v_ies
vigs85427282v_igs
vims95423322v_ims
viols86118102viols
viroids1137922viroids
vis66747622v_i_s
voces105918052voces
voes75432822vo_es
voice104915322voice
voices114414012voices
voided114011132voided
voider103611552voider
voiders11279822voiders
voila84813942voila
voile84719722voile
voiles94616442voiles
voles86234042voles
volts85421292volts
vomits112610922vomits
votes84627082votes
vows106626942vo_ws
whids125413992whids
woads94818442woads
wolds95420182wolds
woods95723032woods
words95425072words
yids85224972_yids
yods86531192yo_ds
zooids1637092zooids

Search took 10 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 Filter178691538001.296137878.9
2DLD Change Limit538001387.6407041.9
3Display Results1381380.280492.9
 (SQL Overall)1786911389.21619389.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.