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 “foresighted” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
foresighted195290(None) 
farsighted1842942far_sighted
foresight1645322foresight__
foresightedly24101382foresightedly
foresights1743752foresight_s
freighted1755202f_re_ighted
resighted1436522__resighted
firefighter2172033firefighter
foresightful2261073foresightful
forested12312463fores___ted
freighter1655023f_re_ighter
frighted1657173f_r__ighted
longsighted1751383longsighted
relighted1436863__relighted
shortsighted2061373shortsighted
affrighted2152054affr__ighted
bedighted1744584__bedighted
benighted1644744__benighted
codesigned1542564codesig_ned
copyrighted2351644copyrighted
delighted1546204__delighted
farsightedly2361244far_sightedly
firefight1944134firefight__
firefighters2271724firefighters
firefights2043314firefight_s
firelight1655534firelight__
firelights1764014firelight_s
flighted1646974f___lighted
floodlighted2161014floodlighted
forecasted1685104fore_casted
foredated1447684fore__dated
foreigner1344664fore_ig_ner
foresheet1549234fores__heet
foreshorten1752644foreshorten
foreshowed2044064fores_howed
foreside12310304foresi__de_
foresides1339704foresi__des
foresightedness2391914foresightedness
forestalled1553384forestalled
forester11313674fores___ter
foretasted1484754fore_tasted
forfeited1643794forfei__ted
forklifted2151354forkli_fted
fornicated1644824for_nicated
fortnight1643794fortnight__
fortnightly2151234fortnightly
fortnights1752674fortnight_s
fraughted1743604f_r_aughted
freight1447604f_re_ight__
freighters1764124f_re_ighters
freights1555854f_re_ight_s
freshed143312594f_res__h_ed
frighten1566444f_r__ighten
limelighted1851794limelighted
moonlighted1851944moonlighted
nearsighted1651384nearsighted
overlighted1944214_overlighted
overnighted1953994_overnighted
preflighted2172784_preflighted
presifted1536874_presi_fted
resifted12310154__resi_fted
resight11510644__resight__
resights1246734__resight_s
resigned1038864__resig_ned
resinated10413284__resinated
resisted9312694__resi_sted
resited85122424__resi__ted
retighten1374774__retighten
righted122912144__r__ighted
sighted123111524____sighted
skreighed1842454skre_igh_ed
straighted1544864str_aighted
unsighted1455434__unsighted
unweighted1843154unwe_ighted
uprighted1654214upr__ighted
weighted1635594__we_ighted

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit148819768.86016796.7
3Display Results76760.0302533.3
 (SQL Overall)178691769.04619753.6
 
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.