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 “fulfill” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
fulfill134502(None) 
fulfil1246421fulfi_l
fulfills1443651fulfills
fulfils1345721fulfils
fulfilled1642692fulfilled
fulfiller1542782fulfiller
bulbil10389573bulbi_l
bulbils11338333bulbils
bulkily16227123bulkily
faultily1474523faultily
filial93013253fil_ial
fill75540193___fill
filmily1535733filmily
flail85316183f_lai_l
flails94313003f_lails
fluffily1652923fluffily
flukily1735213flukily
fluvial1345363fluvial
frill84917563f__rill
fuggily1534963fuggily
fulfillers1642043fulfillers
fulfilling1742723fulfilling
fulgid1137043fulgi_d
full75229153fu___ll
fulling114019703fulling
fulls84623523ful__ls
fully114820863ful__ly
fulmine1257963fulmine
funkily1736513funkily
funnily1336373funnily
furrily1337613furrily
fusil84715323fu_si_l
fusile94313493fu_sile
fusilli1044233fu_silli
fusils93912343fu_sils
fussily13267603fussily
fustily133111373fustily
futile93914953fu_tile
fuzil173810703fu_zi_l
fuzils18407963fu_zils
fuzzily2145073fuzzily
gulfier1137793gulfier
gulfing12339473gulfing
huffily1934693huffily
infill938413_infill
mudsill1045163mudsill
outfall1039683outfall
outkill1136553outkill
outwill1037323outwill
puffily1834843puffily
pulpily1436103pulpily
pulvilli1342003pulvilli
quill148413773qu__ill
refill94514053_refill
subfile122010503subfile
sulfid1039063sulfi_d
sulfide1138103sulfide
sulfids1137293sulfids
sulfinyl1442953sulfinyl
sulfite10310473sulfite
sulkily14218113sulkily
uphill11106173_uphill

Search took 9 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 Limit134027628.48315799.5
3Display Results62620.0331878.8
 (SQL Overall)178691628.92220028.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.