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

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
fluorescing175290(None) 
fluorescein1662502fluorescein_
fluoresceins1762362fluoresceins
fluorescent1654092fluorescent
efflorescing2161213efflorescing
florescent1545673fl_orescent
flourishing1852563flourishing
fluoresce1473713fluoresc__e
fluoresced1693083fluoresc_ed
fluorescence19103513fluorescence
fluorescents1752793fluorescents
fluorescer1583193fluoresc_er
fluorescers1692703fluorescers
fluoresces1573863fluoresc_es
fluoroscoping2181873fluoroscoping
foresting13311363f__oresting
afforesting1852854afforesting
deforesting1654794deforesting
fleecing14347574fl___eecing
fleshing15339304fl___eshing
floccing16306034fl_o__ccing
flooring12259884floor___ing
florescence1884414fl_orescence
flossing12247904fl_o__ssing
flouncing1533904fl_o_uncing
flouring123010144flour___ing
flowering1636054fl_owe_ring
fluidising1542584fluidis_ing
fluorene1145244fluore___ne
fluorescences2083234fluorescences
fluoridating1752684fluoridating
fluorin1037234fluor___in_
fluorinating1653634fluorinating
fluorine1147814fluor___ine
fluorins1137344fluor___ins
fluoroscope18194284fluoroscope
fluoroscopy21182984fluoroscopy
fluorosis1243924fluoros_i_s
fluoxetine2051484fluoxe_tine
flurrying16162804flu_r_rying
flushing15288834flu___shing
flustering14105934fluste_ring
fluttering14106294flutte_ring
forcing134013754f__or__cing
foredoing1456484f__oredoing
foregoing1455794f__oregoing
foreseeing1444554f__oreseeing
foreskin1547024f__oreskin_
foreskins1647044f__oreskins
forewing1539004f__ore_wing
fortressing1543964fortressing
frescoing1544684f___rescoing
freshing152611024f___reshing
furnacing1543714f_u_rnacing
luminescing1651704_luminescing
obsolescing1651644obsolescing
oleoresin953074oleores_in_
oleoresins1052884oleores_ins
putrescine1453404_putrescine
reforesting1546194reforesting
tumescing1443644_tu_mescing
unresting10311134__unresting

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 Filter1786911488190.406440125.6
2DLD Change Limit148819628.79616918.9
3Display Results62620.0302066.7
 (SQL Overall)178691629.23219355.6
 
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.