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

147 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
fulfils134572(None) 
fulfil1246421fulfil_
fulfill1345021fulfill
fulfills1443651fulfills
bulbils11338332bulbils
flails94313002f_lails
fulls84623522ful__ls
fusils93912342fu_sils
fuzils18407962fu_zils
sulfids1137292sulfids
bulbels11398013bulbels
bulbil10389573bulbil_
bulbuls11346783bulbuls
bulkily16227123bulkily
bullies94121893bullies
bulls75629573bul__ls
cullies94419963cullies
cullis84115993culli_s
culls75425813cul__ls
cupfuls1444343cupfuls
duffels14296453duffels
dulias71212743dul_ias
dulls64523743dul__ls
elfins94810943_elfins
fails85631483f__ails
falafels1453113falafels
fallals103310193fallals
falls85727653fal__ls
falsies103515013falsies
fanfics1535173fanfics
farfals13268503farfals
farfels13348213farfels
faultily1474523faultily
felafels1452853felafels
felids103111623fel_ids
fellies104119743fellies
fells85327383fel__ls
fibrils1236843fibrils
fillies103420253fillies
fillips12298133fillips
fills84632373fil__ls
filmily1535733filmily
filmis114610283filmi_s
fils75838693___fils
flail85316183f_lail_
flairs95711913f_lairs
flics105418363f_l_ics
flies85630713f_l_ies
flips105117743f_l_ips
flirs85518933f_l_irs
flits85625223f_l_its
fluffily1652923fluffily
fluffs11347783fluf_fs
fluids10349423f_luids
flukily1735213flukily
foils85025813f__oils
folios93915463fol_ios
folkies143612253folkies
follies103618943follies
follis93113903folli_s
fossils10379013fossils
frails93716473f_rails
frazils1956123frazils
fucoids1335663fucoids
fuddies123211203fuddies
fuels87117353fu__els
fuggily1534963fuggily
fugios1037583fu_gios
fujis15379243fu_ji_s
fulfilled1642693fulfilled
fulfiller1542783fulfiller
fulfillers1642043fulfillers
fulgid1137043fulgi_d
fulhams1543983fulhams
full75229153ful__l_
fullams1236553fullams
fullers103817373fullers
fulling114019703fulling
fully114820863ful__ly
fulmars1246423fulmars
fulmine1257963fulmine
fulmines1357783fulmines
fulness10248963fulness
fulvous1334543fulvous
funfairs1442133funfairs
fungals11276783fungals
funkias1435383funkias
funkily1736513funkily
funnels10348173funnels
funnies104113603funnies
funnily1336373funnily
furies95126373fu_ries
furls85322053fu__rls
furrily1337613furrily
fusains1038363fusains
fusels94412453fu_sels
fusil84715323fu_sil_
fusile94313493fu_sile
fussily13267603fussily
fustics1279593fustics
fustily133111373fustily
futile93914953fu_tile
fuzil173810703fu_zil_
fuzzily2145073fuzzily
fylfots1642423fylfots
gulfier1137793gulfier
gulfiest1247953gulfiest
gulfing12339473gulfing
gulfs94915303gulf__s
gullies84717313gullies
gulls65222983gul__ls
huffily1934693huffily
huipils1243533huipils
hulls84923563hul__ls
jugfuls1843063jugfuls
kufis1249253ku_fi_s
lulls54119653lul__ls
milfoils1343893milfoils
muffins15308343muffins
mugfuls1344003mugfuls
mulls75124153mul__ls
nulls55019983nul__ls
outfits102210833outfits
puffily1834843puffily
puffins15278913puffins
pulis74225603pul_i_s
pulls74425053pul__ls
pulpily1436103pulpily
pulpits1137243pulpits
pupils10389913pu_pils
quails153412643qu_ails
subfile122010503subfile
subfiles131710723subfiles
sulfas9311563sulf_as
sulfid1039063sulfi_d
sulfide1138103sulfide
sulfides1238053sulfides
sulfinyls1542273sulfinyls
sulfite10310473sulfite
sulfites1139903sulfites
sulfurs1037343sulfurs
sulkies114315763sulkies
sulkily14218113sulkily
sullies74122233sullies
tubfuls1245483tubfuls
tulips8137253tul_ips
unfits93910293_unfits

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.1531167915.0
2DLD Change Limit1340271476.75019855.9
3Display Results1471470.0632333.3
 (SQL Overall)1786911476.96625651.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.