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

53 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
sightlier134445(None) 
highflier1942282highflier
mightier1436382might_ier
sighter113412112sight__er
sightliest1445112sightliest
sightline1345682sightline
sightlines1465752sightlines
sightseer1343312sightseer
sprightlier1751882sprightlier
unsightlier1551662unsightlier
eighties12710803eight_ies
fighter143010773fight__er
flightier1644423flight_ier
gigglier1154323gig_glier
highfliers2051823highfliers
highflyer2251643highflyer
jigglier1754093jig_glier
lightener1345693lightener
lighter113113443light__er
nigglier1044843nig_glier
nightie1179653night_ie_
nighties121011383night_ies
nightlife1683733nightlife
nightlifes1793753nightlifes
nightlives1763803nightlives
righter113212383right__er
righties12711573right_ies
saintlier954623saintlier
shalier103116423s__halier
sicklier1457213si_cklier
sigher103813703sigh___er
sighlike1635533sigh_like
sighted123111523sight__ed
sighters122510603sight__ers
sighting133110863sight_ing
sightless1385923sightless
sightliness1574563sightliness
sightly14408273sightl__y
sightsee1245473sight_see
sightseen1343193sightseen
sightseers1452543sightseers
sightsees1344543sightsees
signaler945453signal_er
signaller1043693signaller
signifier1345713signifier
sillier74017593si__llier
siltier73413863si_lt_ier
slighter1257823slight__er
tightener1344703tightener
tighter112910693tight__er
tightwire16102853tightwire
weightier1643313weight_ier
wigglier1354453wig_glier

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.440406115.9
2DLD Change Limit148641536.23323847.4
3Display Results53530.0331606.1
 (SQL Overall)178691536.70626646.4
 
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.