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

98 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
infights154557(None) 
infight1437451infight_
insights1245491insights
fights133816552__fights
gunfights1742432gunfights
infighter1644272infighter
infighters1743322infighters
inflight1545892inflight_
insight1137912insight_
knights1545652kn_ights
nights104117722_n_ights
refights1555882refights
unsights1244622unsights
affrights1942893affrights
alights113211433_alights
bedights1544743bedights
bights124417963__bights
blights133110213_blights
brights133710233_brights
catfights1842793catfights
delights1347333delights
dights114016963__dights
dogfights1842033dogfights
eights103618983__eights
fanlights1643923fanlights
fight124027093__fight_
finfishes1846043finfishes
firefights2043313firefights
fistfights2052173fistfights
flights143310983_flights
freights1555853freights
frights14339623_frights
gunfight1643493gunfight_
heights14399443_heights
hights133716893__hights
hindsights1851923hindsights
incipits1246263incipits
indicts103210723indi_cts
indigens10288733indigens
indigents11208273indigents
indigoes10276783indigoes
indigos9347823indig_os
infants102210773inf_ants
infarcts1345233infarcts
infects12279713inf_ects
infests10279793inf_ests
infidels1244123infidels
infields1244013infields
infighting1844413infighting
infightings1952103infightings
infinite1149593infinite
infinites1258693infinites
infinity1447313infinity
infirms1245563infi_rms
infixes17238133infi_xes
inflects1336193inflects
inflicts1345613inflicts
infought1543523infought_
infracts1346623infracts
ingots7912063in__gots
inhibits1345203inhibits
insists739083insi_sts
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
outfights1643783outfights
penlights1544203penlights
pinfishes1746243pinfishes
plights13299313_plights
refight1488873refight_
relights1248053relights
resights1246733resights
rights104019333__rights
sennights1343433sennights
sights103818013__sights
sleights12275913sleights
slights112810723_slights
sprights14167143sprights
sunlights1344003sunlights
tights104015853__tights
tonights1244593tonights
unfits93910293unfi__ts
unsight1137483unsight_
unweights1643203unweights
uplights14165053uplights
uprights14145313uprights
weights14409553_weights
wights133315783__wights
wrights14318993_wrights

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162986.33023090.4
3Display Results98980.0303266.7
 (SQL Overall)178691986.51327436.1
 
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.