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

78 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
determine124903(None) 
determined1455821determined
determiner1345481determiner
determines1358431determines
degerming1435752degerming
deperming1537112deperming
deterging1237852deterging
determent121312902determent
determinate1446622determinate
determiners1444642determiners
deterring1138622deterring
detersive1346342detersive
extermine1848282extermine
redetermine14103692redetermine
centerline1247043centerline
dateline9810353date_line
decerning1337293decerning
deeming113913123de_e_ming
deerlike1335723de_erlike
deferment151210303deferment
deferring1436143deferring
deforming1636703deforming
demerging1436643demerging
deserting11713143deserting
deserving1497903deserving
detecting13259983detecting
detective1548103detective
deterge9118463deter__ge
detergent11129573detergent
determents131010313determents
determinable1754023determinable
determinacy1953083determinacy
determinant1454733determinant
determinedly1952493determinedly
determining1545293determining
determinism1654063determinism
determinist1455203determinist
deterrence1345623deterrence
deterrent10128943deterrent
detersives1444953detersives
detesting112610323detesting
dethrone1247563dethr_one
detrain8412253det_rain_
detrained1158913det_rained
detrains9411763det_rains
deuteride1145543deuter_ide
deworming1635043deworming
dextrine1688253dextr_ine
ermine8416923___ermine
eserine7415903_eser_ine
etamine91313073_et_amine
eterne6311723_eter__ne
eternise8119663_eternise
eternize17118363_eternize
extermined2045323extermined
extermines1947783extermines
interline91218003interline
ketamine14157053ket_amine
metering112915633meter_ing
nemertine1147073nemertine
nevermind1543303nevermind
overmine13313663_overmine
pelerine10313013peler_ine
petering112516813peter_ing
predetermine1783173predetermine
redetermined16102623redetermined
redetermines15113413redetermines
reserpine1147523reserpine
reteaming122110443reteaming
spermine12311433_spermine
terming104016003__terming
termini93410813__termini
termite9313893__termite
terrine72517573__terrine
undermine122012233undermine
undetermined1653023undetermined
uterine7315193_uter_ine
waterline1249653waterline

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.1731032896.0
2DLD Change Limit148641787.84318952.1
3Display Results78780.0302600.0
 (SQL Overall)178691788.04622208.7
 
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.