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

42 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
flightily194335(None) 
flightier1644422flightier
flighting1736102flighting
flighty17347432flight__y
flintily1434892fli_ntily
lightly14369022_light_ly
mightily1744622_mightily
slightly1544602slight_ly
weightily1942462weightily
alighting1446413alighting
blighties1546223blighties
blighting1635733blighting
blighty16356843blight__y
brightly1764553bright_ly
doughtily1742373doughtily
eighthly1843703_eighthly
feistily1445263fei_stily
fighting162710083f_ighting
filthily1743663filth_ily
fishily1637643f_ish_ily
flashily1735473flash_ily
flauntily1542653flauntily
fleshily1744533flesh_ily
flight134014813flight___
flighted1646973flight_ed
flightiest1744503flightiest
flights143310983flight__s
flimsily1643283fli_msily
frighting1736023frighting
haughtily1941993haughtily
knightly1953013knight_ly
lichtly15255523_licht_ly
lighting132811833_lighting
lightish1556623_lightish
naughtily1642283naughtily
nightly14449033_night_ly
plighting1635563plighting
rightly14389043_right_ly
sightly14408273_sight_ly
slighting1436373slighting
slightingly1952263slightingly
tightly14327613_tight_ly

Search took 8 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 Limit148641427.28320409.3
3Display Results42420.0133230.8
 (SQL Overall)178691427.71623158.5
 
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.