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

96 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
insights124549(None) 
infights1545571infights
insight1137911insight_
unsights1244621unsights
hindsights1851922hindsights
infight1437452infight_
insists739082insi_sts
knights1545652kn_ights
nights104117722_n_ights
resights1246732resights
sights103818012__sights
unsight1137482unsight_
alights113211433_alights
bedights1544743bedights
bights124417963__bights
blights133110213_blights
brights133710233_brights
delights1347333delights
dights114016963__dights
eights103618983__eights
ensigns836353ensig_ns
eyesights1642203eyesights
fanlights1643923fanlights
fights133816553__fights
flights143310983_flights
freights1555853freights
frights14339623_frights
gaslights1463753gaslights
gunfights1742433gunfights
heights14399443_heights
hights133716893__hights
hindsight1753033hindsight_
incipits1246263incipits
indicts103210723indi_cts
indigens10288733indigens
indigents11208273indigents
indigoes10276783indigoes
indigos9347823indig_os
infighter1644273infighter
infighters1743323infighters
inflight1545893inflight_
ingots7912063in__gots
inhibits1345203inhibits
insects93710843ins_ects
inserts74013993ins_erts
insets64016133ins__ets
insiders947763insiders
insides8512653insi_des
insightful1751443insightful
insigne837673insig_ne
insignia943663insignia
insignias1043543insignias
insist6314513insi_st_
inspects1255863inspects
inspirits1144253inspirits
instants8910153instants
instigate1048613instigate
instigates1148423instigates
instincts1144533instincts
insults7268963ins_ults
inveighs1542743inveigh_s
knight1438173kn_ight_
lights104519913__lights
midnights1642683midnights
mights123516253__mights
mislights1544663mislights
naughts11447513_naughts
neighs10387733_neigh_s
nighs95013613_n_igh_s
night94327853_n_ight_
nighty135611273_n_ighty
noughts11478083_noughts
outsights1344183outsights
penlights1544203penlights
plights13299313_plights
refights1555883refights
relights1248053relights
resight11510643resight_
rights104019333__rights
sennights1343433sennights
sighs95416743__sigh_s
sight94629293__sight_
sleights12275913sleights
slights112810723_slights
sprights14167143sprights
sunlights1344003sunlights
tights104015853__tights
tonights1244593tonights
unsighted1455433unsighted
unsightly1643083unsightly
unweights1643203unweights
uplights14165053uplights
uprights14145313uprights
weights14409553_weights
wights133315783__wights
wrights14318993_wrights

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 Filter1786911461620.420425454.8
2DLD Change Limit146162967.30020022.2
3Display Results96960.0303200.0
 (SQL Overall)178691967.75023056.9
 
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.