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

88 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
fleetness124475(None) 
alertness946052alertness
feetless1137382f_eetless
flatness1138152fl_atness
fleetest1136722fleet_est
fleetnesses1445482fleetnesses
freeness11710442free_ness
meetness1036652_meetness
sleekness1344542sleekness
sweetness1245682sweetness
adeptness1273953adeptness
alienness945373alienness
bleakness1543593bleakness
blueness1038213blue_ness
bluntness1144343bluntness
cleanness1144973cleanness
clearness1135633clearness
cleverness1543223cleverness
deepness1136443_deepness
deftness1236303_deftness
effeteness1643673effeteness
electress1146113electress
erectness1146123erectness
fadedness1445613fadedness
faintness1235833faintness
falseness1236093false_ness
fastness11238763f_astness
fatness103311293f__atness
feeless103511103f_ee_less
fellness1135913f_ellness
fewness1335003f__ewness
feyness1334923f__eyness
fieriness1238623fieriness
fineness11310643fine_ness
firstness1245013firstness
fitness10299393f__itness
fixedness2043713fixedness
flakiness1636473flakiness
fleckless1842893fleckless
fleecers13325933flee_cers
fleeces12399643flee_ce_s
fleeches16287083fleeche_s
fleeciest1434873fleeciest
fleeted113310233fleet_e_d
fleeter103210363fleet_e_r
fleetingness1652653fleetingness
fleets96915063fleet___s
flenses1039473fl_e_nses
fleshiness16104293fleshiness
fleshless1543993fleshless
flintiness1345893flintiness
fluidness1344293fluidness
flukiness1635453flukiness
flushness1544893flushness
freshness1545943freshness
fretless1138063f_retless
gleetiest1035913gleetiest
glegness1034613gl_egness
glueyness1342913glueyness
greatness1036903greatness
greenness1046793greenness
ineptness1145073ineptness
inertness947973inertness
keenness1234883_keenness
lateness82614073_lateness
leanness837373_leanness
leeriness938323_leeriness
levelness1245453_levelness
lewdness1254173_lewdness
liteness82213213_liteness
lostness837683_lostness
meekness1434303_meekness
neatness839153_neatness
overtness1238223overtness
pertness10310093_pertness
pleatless1134613pleatless
queerness1844213queerness
quietness1844753quietness
selectness1245453selectness
sheerness1236273sheerness
sheetless1235823sheetless
silentness1044573silentness
sleepiness1245133sleepiness
sleepless1144553sleepless
sleetiest938553sleetiest
steepness1145723steepness
tweeness11246403twee_ness
wetness10277723__wetness

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 Filter1786911486410.420425454.8
2DLD Change Limit148641886.12624264.0
3Display Results88880.0461913.0
 (SQL Overall)178691886.59227107.3
 
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.