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
voids9541467(None) 
avoids104410201avoids
loids66220701loids
ovoids10456921ovoids
vids85627531v_ids
void86220561void_
acids87121002acids
aids57846352_aids
amids85627502amids
aroids75118222aroids
avoid95516672avoid_
bids75838422_bids
bods76244712bo_ds
boils75427192boils
bolds85825282bolds
bonds86126842bonds
bovids1287972bovids
caids85226422caids
cods76848102co_ds
coeds85920162coeds
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
colds85726972colds
cords86030622cords
doits66223672doits
droids84712582droids
fids87034732_fids
foils85025812foils
foins85523382foins
folds95221692folds
fonds95824822fonds
foods95924162foods
fords95328182fords
geoids8369842geoids
gids65933732_gids
goads77022852goads
gods65438042go_ds
golds75421312golds
goods75124482goods
gowds105814042gowds
grids75321392grids
guids75516152guids
hods87239862ho_ds
holds94623242holds
hoods95124082hoods
hyoids1377672hyoids
ids47535462__ids
imids86015122imids
iodids83711142iodids
irids66417762irids
joins125818412joins
kids96029632_kids
kois85129392koi_s
lids56336452_lids
loads65323372loads
loid55531482loid_
loins56728422loins
lords64923502lords
maids86327132maids
mids76541772_mids
mods77945052mo_ds
moils76125742moils
molds85324832molds
moods85224622moods
nods55838222no_ds
noils55024332noils
noirs55615462noirs
odds68919922_odds
ods47546212_o_ds
oils46337972_oils
olds55926572_olds
ootids71110352ootids
ouds56430102_ouds
ovoid94811022ovoid_
oxids13128962oxids
pods76540152po_ds
poinds93511142poinds
pois66539042poi_s
ponds85323402ponds
poods85124752poods
qaids156116312qaids
quids154917462quids
raids65827512raids
rids56539542_rids
roads66523612roads
rods56442062ro_ds
roils54826792roils
roods65125282roods
saids65328852saids
skids104615322skids
sloids73712692sloids
sods54940212so_ds
soils55327982soils
solids74116402solids
sords64527802sords
toads65621062toads
tods56141842to_ds
toils54527492toils
toits55327472toits
vails85825932vails
vairs85019132vairs
veils84918802veils
veins84620492veins
velds95615582velds
vends95520892vends
vid77241802v_id_
vide85432752v_ide
vies75238622v_ies
vigs85427272v_igs
vims95423312v_ims
viols86118102viols
viroids1137922viroids
vis66747612v_i_s
voces105918052voces
voes75432822vo_es
voice104915322voice
voices114414012voices
voided114011132voided
voider103611552voider
voiders11279822voiders
voila84813942voila
voile84719722voile
voiles94616442voiles
voles86234042voles
volts85421292volts
vomits112610922vomits
votes84627082votes
vows106626942vo_ws
whids125413982whids
woads94818442woads
wolds95420182wolds
woods95723032woods
words95425072words
yids85224952_yids
yods86531182yo_ds
zooids1637092zooids

Search took 3 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.0931921408.6
2DLD Change Limit538001381.90628226.7
3Display Results1381380.0761815.8
 (SQL Overall)1786911382.07586116.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.