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

87 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
solids7411640(None) 
sloids73712691sloids
solid65025081solid_
solidi73813151solidi
solidus8338111solidus
bolds85825282bol_ds
bolide9515562bolide
bolides10515072bolides
bovids1287972bovids
colds85726972col_ds
colics104219902colics
colies84837052colies
colins85229042colins
felids103111622felids
folds95221692fol_ds
folios93915462folios
golds75421312gol_ds
halids104016132halids
holds94623242hol_ds
holies94630032holies
iodids83711152iodids
lids56336462__lids
loids66220702lo_ids
molds85324832mol_ds
molies84429512molies
olds55926572_ol_ds
olios54520852_olios
ootids71110352ootids
oxids13128962_oxids
polies84034582polies
polios84019722polios
polis74731162poli_s
psocids1234862psocids
saids65328852s_aids
salads75316962salads
salpids1038192salpids
sayids104310972sayids
scolds95011232scol_ds
sialids839722sialids
silds65520522sil_ds
skids104615332s_kids
sleds64418852s_leds
slid55828982s_lid_
slide64725412s_lide
slides73922182s_lides
slims75423652s_lims
slips76023722s_lips
slits56128852s_lits
sloid64619712sloid_
slojds14345472slojds
sloyds10346292sloyds
sods54940212so__ds
soils55327982so_ils
solands84412342solands
solans64122492solans
sold54837412sol_d_
soldi65717202sol_di
soldo67116562sol_do
soled65835172soled_
soles55547922sol_es
soleus64615612soleus
soli46637012soli__
solider82912452solider
solidest9310382solidest
solidly1137352solidly
soling74226822soling
solion6616382solion
solions7513752solions
solons65120022solons
solos54830792sol_os
sols45448162sol__s
solums85211332solums
solus54726982sol_us
solves95018222solves
sonics84315632sonics
sords64527802so_rds
sounds74616182sounds
sozins15510792sozins
splits85416412splits
squids16409802squids
stolid74213182stolid_
sulfids1137292sulfids
sylis84316022syli_s
toluids835322toluids
voids95414672vo_ids
wolds95420182wol_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 Filter178691825510.376475242.0
2DLD Change Limit82551872.43633887.9
3Display Results87870.0302900.0
 (SQL Overall)178691872.84262875.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.