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

86 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
fulmined145433(None) 
fulmine1257961fulmine_
fulmines1357781fulmines
fulminated1645022fulminated
fulminic1543492fulminic
unmined102612952_unmined
alined75221403_al_ined
alumine9412693alumine_
alumines10411673alumines
bullied104514813bulli_ed
buskined1534443buskined
bylined1335853byl_ined
calamined1447423calamined
calcined1338743calcined
cullied104012353culli_ed
culmed114610593culm__ed
culminated1546103culminated
culming123811183culmin_g
dulcinea1143263dulcinea
dummied13346723dummi_ed
eloined8149813_eloined
ermined10410603_ermined
examined18135863examined
famine114318193f_amine_
famines123216263f_amines
feline94820143fel_ine_
felines104718073fel_ines
filliped1435223filliped
filmed124610363film__ed
filmier1237503filmi_er
filminess1435983filminess
filming133210353filmin_g
fined94930503f___ined
flailed1137303f_lailed
flamines13311623flamines
flied96519433f_l_i_ed
flinted114411893f_l_inted
flited104616583f_l_ited
flumed124915263flum__ed
fluming133512793flumin_g
flumped15377713flum_ped
foined105915013f__oined
folioed1138033fol_ioed
fulfilled1642693fulfilled
fulgid1137043fulgi__d
fulled103820653ful__led
fullered1236383fullered
fulling114019703fullin_g
fulminant1454173fulminant
fulminate1446553fulminate
fulminates1545883fulminates
fulmining1554403fulmining
fumbled153710493fu_mbled
fumed116118823fu_m__ed
fumier11310903fu_mi_er
fuming124013293fu_min_g
funned103613953fu__nned
furriner11267283furriner
gullied93812063gulli_ed
gumline102810113gumline_
gumlines11238573gumlines
illumined1243633illumined
limned94811473__limned
lined64934643__l_ined
mined85333353___mined
mullioned1245733mullioned
multiped1337373multiped
mummied11327103mummi_ed
mutined103311353mu_tined
outlined92512953outlined
plained103812233_plained
plumiped1533313plumiped
pumiced1435173pu_miced
purloined1243703purloined
quoined1735783qu_oined
relined85321933rel_ined
relumined1245363relumined
ruined74813323ru__ined
splined105013113spl_ined
sullied83714483sulli_ed
summited13246393summited
summoned1345723summoned
surmised1136853surmised
unlined82515803_unlined
unmixed17228213_unmixed
vulpine1235903vulpine_

Search took 10 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 Filter1786911461620.313570897.8
2DLD Change Limit146162869.15615963.5
3Display Results86860.0332606.1
 (SQL Overall)178691869.50218805.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.