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

107 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
resighted143652(None) 
relighted1436861relighted
bedighted1744582bedighted
benighted1644742benighted
delighted1546202delighted
foresighted1952902foresighted
freighted1755202fre_ighted
resifted12310152resi_fted
resight11510642resight__
resights1246732resight_s
resigned1038862resig_ned
resinated10413282resinated
resisted9312692resi_sted
resited85122422resi__ted
retighten1374772retighten
righted122912142r__ighted
sighted123111522__sighted
unsighted1455422unsighted
weighted1635592we_ighted
alighted1347673_alighted
beknighted2151863beknighted
bighted142810923__bighted
blighted1546863_blighted
delighter1445583delighter
designated1345933designated
designed1136943desig_ned
desisted1039783desi_sted
dighted132511493__dighted
farsighted1842943farsighted
flighted1646973_flighted
freighter1655023fre_ighter
frighted1657173_frighted
heighten1545703he_ighten
hesitated1377783hesitated
highted152710163__highted
knighted1745123_knighted
levigated1445643levigated
lighted122913503__lighted
mislighted1743653mislighted
nearsighted1651383nearsighted
neighed12135893ne_igh_ed
plighted1546463_plighted
preflighted2172783preflighted
presifted1536873presi_fted
recited104319103reci__ted
redigested1354113redigested
refight1488873refight__
refights1555883refight_s
refigured1443933refigured
refitted12309413refi_tted
reigned949213re_ig_ned
reignited1145683re_ignited
rejigged1833683rejig_ged
relegated1139763relegated
relight11512063relight__
relights1248053relight_s
relished1239433relish_ed
relisted9312623reli_sted
remigrated1447493remigrated
reminted113615083remi_nted
remitted113312073remi_tted
renigged1135053renig_ged
rerigged1136243rerig_ged
resaluted1046473resaluted
reseated93220263res_eated
resected112514743res_ected
resented92716963res_ented
reshoed112212153res__hoed
resided95217703resi__ded
resighting1546073resighting
resigner937793resig_ner
resiled84621983resi__led
resinate8316773resinate_
resinates9314763resinates
resined84522653resi__ned
resister8311653resi_ster
resite64128453resi__te_
resites74027793resi__tes
resituated1147323resituated
resized174614903resi__zed
reslated93517523res_lated
resmelted1236033resmelted
resonated10510613resonated
resorted9313493res_orted
respected1438493respected
respited11410813res_pited
respotted1235953respotted
restarted10410053restarted
restated93120173res_tated
rested74430783res___ted
restituted1156523restituted
resulted939713res_ulted
retightened1652433retightened
retightens1453683retightens
retinted94414363reti_nted
revisited1346573revisited
reweighed1742903reweigh_ed
righter113212373r__ighter
sighed113712053__sigh_ed
sighter113412103__sighter
slighted1357393_slighted
unlighted1455773unlighted
uplighted1653843uplighted
uprighted1654213uprighted
vesicated15117653vesicated
weighed15135933we_igh_ed
weighter1535603we_ighter

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411078.18618158.0
3Display Results1071070.0631698.4
 (SQL Overall)1786911078.40521260.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.