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

105 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
fluency154535(None) 
affluency20102682affluency
fleecy14266482fl_eecy
flench144010812fl_ench
flouncy1543672flouncy
fluent9313932fluen_t
fluently1445132fluently
flunky16408092flu_nky
lucency14104902_lucency
affluence17103783affluence
agency1237033_agency
alienly1037503alienly
ardency1346483ardency
blench133710453bl_ench
blenny1156203bl_enny
bluejay1942723bluejay
bluely113310083blue_ly
bluesy11448983blue_sy
bluey104817053blue__y
bouncy13409073bou_ncy
cadency1545893cadency
clemency1743693clemency
clench133910053cl_ench
clunky15447893clu_nky
cogency1547013cogency
decency1537453decency
effluence17104073effluence
eluent6315483eluen_t
eluents738703eluents
faience1237523faience
fancy134615483f__ancy
fence105319913f__ence
fenny115115133f__enny
fervency1944383fervency
flamenco1543193flamenco
flatulency1891913flatulency
flaunty1354413flaunty
fleck148213593fl_e_ck
flecky18387653fl_ecky
fledgy14414913fl_edgy
fleece11369903fl_eece
fleech14367343fl_eech
fleetly1336323fleetly
flense938903fl_ense
fleshy15406283fl_eshy
fletch14388193fl_etch
fleury12417353fl_eury
fley106626853fl_e__y
flinch144010103fl_inch
flinty126112493fl_inty
florence1347063florence
flounce1235413flounce
flue75329853flue___
flued95021253flue__d
fluencies1445933fluencies
flueric1246143flueric
fluerics1345393fluerics
flues84626923flue__s
fluffy14315783flu_ffy
fluidly1434813fluidly
flukey16459813flu_key
flukily1735213flukily
fluky154512293flu__ky
flung95114583flu_n_g
flunk125014383flu_n_k
flunkey17405793flunkey
flunks13469863flu_nks
flurry12397113flu_rry
flutey125212523flu_tey
fluty114415643flu__ty
french143511213f_rench
frenzy2135883f_renzy
frequency2653403frequency
frumenty1644573frumenty
funky154315133f_u_nky
funny114614833f_u_nny
gluey95715263glue__y
glunch1255353glu_nch
influence1446103influence
jouncy18336203jou_ncy
latency1236033latency
lucence11148003_lucence
lunacy1136843_lunacy
lunch104917243_lu_nch
luny77324133_lu_n_y
nonfluency1853233nonfluency
opulency1543323opulency
patency1466313patency
plench134010813pl_ench
plenty11311413pl_enty
pliancy1435593pliancy
plunky15377953plu_nky
potency1457433potency
pudency1544763pudency
quench2036633_quench
recency1438633recency
refluence1445863refluence
regency1337363regency
saliency13125393saliency
sequency2244493sequency
sluicy1166483slu_icy
solvency1644023solvency
truancy1244993truancy
urgency1345663urgency
valency1565463valency

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.420425454.8
2DLD Change Limit1340271058.47015823.7
3Display Results1051050.0303500.0
 (SQL Overall)1786911058.92020032.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.