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

68 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
prefight174639(None) 
preflight1844671preflight
refight1488871_refight
firefight1944132firefight
freight1447602fre_ight
preflights1943322preflights
prizefight2851512prizefight
refights1555882_refights
relight11512062_relight
resight11510642_resight
aright103817663ar__ight
bedight1437483_bedight
bright124215923br__ight
catfight1744273catfight
delight12610673_delight
dogfight1742993dogfight
dreigh11246443dre_igh_
eight94928053__e_ight
eyesight1543523eyesight
fight124027093___fight
firefights2043313firefights
firelight1655533firelight
foresight1645323foresight
freights1555853fre_ights
fright133715243fr__ight
gunfight1643493gunfight
height134713433_he_ight
infight1437453_infight
outfight1546103outfight
penlight1446423penlight
plight123513363p__light
prebirth1543463prebirth
prebought17113153prebought
precinct1459423precinct
predict12315323predi_ct
predigest1357633predigest
prefect141011073pref_ect
prefigure1544043prefigure
prefile123413183prefi_le
prefiled143310573prefiled
prefiles133113443prefiles
prefire124012813prefi_re
prefired144310753prefired
prefires134313283prefires
prefix18356853prefi__x
prefixal2044543prefixal
prefixed21357703prefixed
prefixes20389233prefixes
preflighted2172783preflighted
prelimit1259123prelimit
premixt183510663premi_xt
preriot9316413preri_ot
presift12312223presi_ft
previsit13410073previsit
preweigh1753683preweigh_
preweighs1872713preweighs
prizefights2951293prizefights
profit113016273profi__t
refit84230063_refi__t
refought1564243_refought
relights1248053_relights
resights1246733_resights
right94430503_r__ight
sleight11279023sle_ight
spright132010403spr__ight
upright13178293upr__ight
weight133914183_we_ight
wright133713513wr__ight

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.423422437.4
2DLD Change Limit146162686.70321805.5
3Display Results68680.0302266.7
 (SQL Overall)178691687.15624970.8
 
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.