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

220 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
foliums123717(None) 
folium11310451folium_
alliums957972alliums
coniums11311862coniums
foldups1332732foldups
folios93915462foli_os
folious103710732folious
forums114611842fo_rums
heliums12188302heliums
holisms123811112holisms
holmiums1544152holmiums
ioniums938302ioniums
kaliums1336602kaliums
odiums9337942_odiums
oleums8358782_oleums
opiums10307072_opiums
podiums12227632podiums
sodiums10177212sodiums
solums85211332sol_ums
albums10198273_albums
algums9208043_algums
allium8311243allium_
alums75720603_al_ums
atriums939043atriums
bariums1139143bariums
bohriums1593923bohriums
bolides10515073bolides
bolus79125543bol_u_s
boojums1842653boojums
calciums1446163calciums
ceriums1139473ceriums
cesiums1136303cesiums
cilium104311373cilium_
coleus86818273coleu_s
colics104219903coli_cs
colies84837053coli_es
colins85229043coli_ns
coliseums1342853coliseums
colitis92617353colitis
colours95913443colours
column1038103col_umn
columns1136473col_umns
conium10415313conium_
corium10315723corium_
curiums1138503curiums
doldrums1243053doldrums
dolours8438823dolours
doums85417643do__ums
eoliths10318573eoliths
eonisms92811043eonisms
erbiums1135463erbiums
fanums1137263f_anums
favisms1535443favisms
felids103111623feli_ds
felines104718073felines
fermiums1544353fermiums
ferrums1265983ferrums
filings115213073filings
films105617963f__ilms
filum105015433fil_um_
firms105217423f__irms
flams105125013f_l_ams
fleams115011943f_leams
flicks154512993f_licks
flics105418363f_li_cs
fliers94417193f_liers
flies85630713f_li_es
flimsy14345563f_li_msy
flings106715283f_lings
flints95617453f_lints
flips105117743f_li_ps
flirs85518933f_li_rs
flirts95411483f_lirts
flites95122443f_lites
flits85625223f_li_ts
flours94414053f_lours
flouts94315273f_louts
flubs105515443f_l_ubs
flues84626923f_l_ues
fluids10349423f_luids
flume106021173f_l_ume
flumes115119733f_l_umes
flump124614723f_l_ump
flumps135112503f_l_umps
flus75626543f_l_u_s
foams105017953fo__ams
focus105815883fo_cu_s
foetus958523foetu_s
fogies104118063fogi_es
fogyisms1743283fogyisms
foils85025813fo_i_ls
foins85523383fo_i_ns
foists95413983fo_ists
folates103218453folates
folders113514393folders
foldouts1244793foldouts
folds95221693fol__ds
foldup1233813foldu_p
foleys123810463fol_eys
folia83618933foli__a
foliage1147533foliage
foliages1247623foliages
foliar93210973foli_ar
foliate10513533foliate
foliates11412753foliates
folic105319323foli__c
folio83820883foli__o
folioed1138033folioed
foliose10378013foliose
folkies143612253folkies
folks126017123fol__ks
folles93820473fol_les
follies103618943follies
follis93113903fol_lis
follows13409923follows
fomites123613203fomites
fondues11399313fondues
fondus105210943fondu_s
forams115115913fo_rams
forints10411833forints
forms105327053fo__rms
forum108318763fo_rum_
foulings12327943foulings
fouls87221433fo__uls
fours85521493fo__urs
fowlings15377243fowlings
foxings18446963foxings
frenums1236203frenums
frolics1236833froli_cs
fulcrums1542353fulcrums
fulhams1543983fulhams
fullams1236553fullams
galliums1145963galliums
glims87417673_gli_ms
glums84621423_gl_ums
golems939323gol_ems
gonium949803gonium_
helium112311253helium_
hokums1533923ho_kums
holdups1333593holdups
holibuts1363953holibuts
holies94630033holi_es
holism113713753holism_
holists104413963holists
holmium1445443holmium_
holms105117803hol__ms
idolisms1146353idolisms
ilium74614183_ilium_
indiums1037143indiums
iodisms10308483iodisms
iolites73819483iolites
ionium8610923ionium_
jorums15408093jo_rums
kalium1239473kalium_
kelims1278913keli_ms
kilims1277903kili_ms
linums838283__linums
locums10478303lo_cums
lums65734243__l_ums
mediums12308723mediums
milium104712683milium_
miniums113910223miniums
modicums1543483modicums
molies84429513moli_es
momisms10308223momisms
monisms113512803monisms
muoniums1244723muoniums
niobiums1243373niobiums
nobeliums1343893nobeliums
nomisms11268743nomisms
oakums1264153_oakums
odeums9367313_odeums
odium83413033_odium_
oleum73613323_oleum_
olios54520853_oli_os
olives94313953_olives
onium73115533_onium_
oolites72817843oolites
ooliths10268323ooliths
opium92812093_opium_
osmiums1134143osmiums
oxims14107643_oxi_ms
palliums1236703palliums
plums94619953_pl_ums
podium112911913podium_
poilus82210573poilu_s
polices113118053polices
polies84034583poli_es
polios84019723poli_os
polis74731163poli__s
poloniums1346053poloniums
porisms113713453porisms
possums1145753possums
protiums1238553protiums
radiums10299313radiums
rhodiums1443763rhodiums
scholiums1644843scholiums
slims75423653_sli_ms
slums74623433_sl_ums
sodium92111453sodium_
solanums1044433solanums
solariums1165923solariums
soleus64615613soleu_s
solids74116403soli_ds
solidus8338113solidus
solions7513753solions
solum74717613sol_um_
solus54726983sol_u_s
talcums1135513talcums
tediums10266973tediums
telium82611393telium_
thoriums13166403thoriums
thuliums1343553thuliums
toluids835323toluids
tolus55024483tol_u_s
trifoliums1552473trifoliums
vellums1235293vellums
volume11358273vol_ume
volumes12298233vol_umes
wholisms1665253wholisms

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.406440125.6
2DLD Change Limit1340272207.42018062.9
3Display Results2202200.0802750.0
 (SQL Overall)1786912207.90622601.9
 
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.