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

58 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
fluoride124587(None) 
fluorid1136781fluorid_
fluorides1345821fluorides
fluorids1245491fluorids
fluorine1147811fluorine
fluorite1147891fluorite
florid10311452fl_orid_
fluorene1145242fluorene
fluoric1245812fluori_c
fluoridate1464012fluoridate
fluorin1037232fluori_n
fluorines1247552fluorines
fluorins1137342fluorins
fluorites1257162fluorites
flurried12235282flurried
alkoxide2083213alkoxide
boride9415903__boride
bourride1144403bourride
chloride143310243chloride
favorite1447313favorite
floodtide14102483floodtide
flooie93712153fl_ooi_e
floorage1275093floorage
floored11268683floored_
flooring12259883flooring
floosie10378933floosi_e
floozie19295463floozi_e
florae94713883fl_or_ae
floridly1554593fl_oridly
florigen12154633fl_origen
florin9312653fl_ori_n
florins10311643fl_orins
florist10314243fl_orist
floured11289873floured_
flouring123010143flouring
flourish1446753flourish
flueric1246143flueri_c
fluerics1345393fluerics
fluid94013963flu__id_
fluidise1254543fluidise
fluidize2153863fluidize
fluids10349423flu__ids
flunkie1434513flunki_e
fluor84512773fluor___
fluorenes1245173fluorenes
fluoresce1473713fluoresce
fluoridated1673263fluoridated
fluoridates1573933fluoridates
fluorinate1365103fluorinate
fluoroses1244943fluoroses
fluors94311373fluor__s
flurries11188913flurries
flybridge1951353flybridge
gloried9169523gl_oried
glucoside1364213glucoside
lurid64618973_lu_rid_
outride82615683_outride
slurried9285943slurried

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 Filter1786911461620.436409841.7
2DLD Change Limit146162586.47022590.7
3Display Results58580.0301933.3
 (SQL Overall)178691586.93625762.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.