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

46 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
flightiest174451(None) 
blighties1546222blighties_
flightier1644422flightie_r
flightiness1843892flightiness
flightless1773392flightless
flintiest1248432fli_ntiest
flirtiest1236192fli_rtiest
lightest121410352_light_est
mightiest1546442_mightiest
slightest13136952slight_est
weightiest1743422weightiest
alightment1693953alightment
brightest1545663bright_est
doughtiest1543233doughtiest
eighties12710803_eighties_
feistiest1237073fei_stiest
filthiest1545373filth_iest
fishiest14310453f_ish_iest
flaggiest14145513flag_giest
flashiest1557993flash_iest
flauntiest1343783flauntiest
fleshiest1576233flesh_iest
fleshliest1642663fleshliest
flighted1646973flight_e_d
flightily1943353flighti_ly
flighting1736103flighti_ng
flights143310983flight__s_
flimsiest1434463fli_msiest
floatiest1237293fl_oatiest
flutiest112610883fl__utiest
glintiest1037623gli_ntiest
haughtiest1742533haughtiest
lightfast1643643_lightfast
lightish1556623_lighti_sh
lightless1386073_lightless
lightness13107433_lightness
lintiest82715913_li_ntiest
naughtiest1442733naughtiest
nighties121011383_nighties_
rightest12149583_right_est
righties12711573_righties_
rightist12159143_righti_st
sightliest1445113_sightliest
slightness1454803slightness
slittiest938213sli_ttiest
tightest12148363_tight_est

Search took 6 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 Filter1786911406030.406440125.6
2DLD Change Limit140603465.45325784.5
3Display Results46460.0331393.9
 (SQL Overall)178691465.89230327.7
 
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.