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

226 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
fulmars124642(None) 
fulmar1137251fulmar_
filmers124211292filmers
fulhams1543982fulhams
fullams1236552fullams
fullers103817372fullers
fumers113613382fu_mers
pulsars9358912pulsars
vulgars11306532vulgars
almahs118611613_almahs
almas76629773_alma_s
altars64518153_altars
blears85116453_blears
bulbar1039583bulbar_
bulgers105215143bulgers
bulgurs10397113bulgurs
bulwark1645213bulwark
bulwarks1744133bulwarks
bummers133712443bummers
bursars94510893bursars
busbars1138153busbars
calamars1238133calamars
calcars11312653calcars
cellars93713693cellars
chimars144010593chimars
clears84116563_clears
collars93816573collars
cullays12347703cullays
cullers93418853cullers
culms95314193culm__s
culvers12329833culvers
cummers133713483cummers
cymars13599153_cymars
damars93815003_damars
dammars12308193dammars
dollars83311023dollars
dolmans10479683dolmans
dolmas95213043dolma_s
dulias71212743dulia_s
dullard936603dullard
dullards1045493dullards
dumas85420433du_ma_s
durbars1077973durbars
fallals103310193fallals
fallers103917993fallers
falters103916473falters
farmers124315263farmers
fears84829393f__ears
fellahs13428393fellahs
fellas95116963fella_s
fellers104117543fellers
felspars1343163felspars
femurs1136713f_emurs
feuars938653f_euars
fiars86720833f__iars
filar84819293fil_ar_
filers94623723fil_ers
fillers104320213fillers
filmcard1642823filmcard
filmcards1742473filmcards
filmer114112403filmer_
filmis114610283film_is
films105617963film__s
filters103816553filters
finmark16154883finmark
finmarks17154473finmarks
firmans12238523firmans
firmers124711443firmers
flabs105818643f_l_abs
flags95321283f_l_ags
flairs95711913f_lairs
flamers124616363flamers
flames114723693f_lames
flams105125013f_l_ams
flans85327973f_l_ans
flaps105621383f_l_aps
flare84823633f_l_are
flares94521703f_l_ares
flats86429743f_l_ats
flaws115920343f_l_aws
flays116321053f_l_ays
fleams115011943f_leams
fleas86423663f_lea_s
fleers96015793f_leers
fliers94417193f_liers
flirs85518933f_l_irs
floats96816253f_loats
floors94112353f_loors
floras94715693f_loras
flours94414053f_lours
flumes115119733flum_es
flumps135112503flum_ps
fluors94311373f_luors
fluters103713683fluters
flyers125712803f_lyers
foamers123812103foamers
folders113514393folders
foliar93210973foliar_
formals123312893formals
formats123113573formats
formers128217953formers
foulard11257283foul_ard
foulards12266463foul_ards
framers125113823framers
friars93812093f_riars
fubar1039923fu_bar_
fuckers163611593fuckers
fuelers103912393fuelers
fuellers11277983fuellers
fuhrers1334813fuhrers
fulcra1135213ful_cra
fulfils1345723fulfils
fulham1435303fulha_m
fullam1138363fulla_m
fuller94220383fuller_
fullery13337973fullery
fulls84623523ful__ls
fulmine1257963fulmine
fulmines1357783fulmines
fulness10248963fulness
fulvous1334543fulvous
fumarase1343563fu_marase
fumaric1446313fu_maric
fumer105918233fu_mer_
fumes105224703fu_m_es
fumets114311813fu_mets
funders113813933funders
funfairs1442133funfairs
fungals11276783fungals
funkers143712063funkers
furans94515953fu_rans
furlers104214223furlers
furors9310953fu_rors
furs76735043fu___rs
fussers104210813fussers
futharc1563713futharc
futharcs1653153futharcs
futhark1744233futhark
futharks1843783futharks
guars65021053gu__ars
guitars8116863guitars
gulags837543gul_ags
gular6314833gul_ar_
gulpers10299013gulpers
gummas114810513gumma_s
gummers123712203gummers
halmas117017893halma_s
hulas84920883hul_a_s
hullers103616263hullers
humans112312433hu_mans
hummers143813063hummers
humors11129633hu_mors
hussars10326983hussars
kulaks976113kul_aks
kulturs1134723kulturs
lars46956573__l_ars
lears55938733__lears
liars54723163__liars
lullers73213353lullers
lumas75622913lu_ma_s
lumbars11289763lumbars
lunars65012813lu_nars
malars85020683mal_ars
mars66261873___mars
molars85517323mol_ars
muggars11316643muggars
mullahs12388733mullahs
mullas84215933mulla_s
mullers93217303mullers
mummers103712843mummers
murmurs1134523murmurs
mylars114310443myl_ars
nullahs10316993nullahs
nummary14314653nummary
oculars948363ocul_ars
outmans92413283outmans
outwars10912793outwars
palmar104113463palmar_
palmary14338553palmary
palmers113513623palmers
pillars9313493pillars
polars84419353pol_ars
pugmark1643463pugmark
pugmarks1742533pugmarks
pulers83820283pul_ers
pullers93618483pullers
pullmans1253933pullmans
pulpers114612283pulpers
pulsar8329363pulsar_
pulsers94213153pulsers
pumas95121563pu_ma_s
quasars1646903quasars
rulers64317093rul_ers
rummers113513653rummers
rumors81110403ru_mors
simars84916933_simars
sugars7312423su_gars
suldans8299723suldans
sulfas9311563sulfa_s
sulfurs1037343sulfurs
sulkers113613343sulkers
sultans72411833sultans
sumacs105512103su_macs
summary14297353summary
summas104313163summa_s
summers113616503summers
talars66021683tal_ars
tolars64817943tol_ars
tumors8810613tu_mors
tussars7359253tussars
ulamas8910453_ulamas
ulans54921303_ul_ans
ulcers839383_ulcers
ulemas888963_ulema_s
ulnar56013983_ulnar_
ulnas55716533_ulna_s
ultras6310193_ultras
ulvas84511503_ulva_s
unbars82113033_unbars
unmans82211993_unmans
uvulars1044413uvul_ars
velars93913723vel_ars
vulgar10426823vulgar_
vulvar12427963vulvar_
vulvas12388843vulva_s
yulans958673yul_ans

Search took 7 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.410435831.7
2DLD Change Limit1340272265.98322401.3
3Display Results2262260.0762973.7
 (SQL Overall)1786912266.46927622.7
 
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.