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

50 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
predicaments195322(None) 
predicament1854751predicament_
medicaments1853712_medicaments
predicants1546062predica__nts
hereditaments1961483hereditaments
medicament1744883_medicament_
pediments1448343p_edi__ments
preachments2044233pre_achments
predicant1449393predica__nt_
predicates15410813predicate__s
eradicants1354244eradica__nts
hereditament1862004hereditament_
indictments1654404_indictments
medicamentous206554_medicamentous
medicants1466784_medica__nts
parliaments1553564parli_aments
pediment13411394p_edi__ment_
preachment1945944pre_achment_
precedents1545724pre__cedents
precents123015034pre__c__ents
prediabetes1652104predi_abetes
predicables1843814predica_bles
predicate14411774predica___te
predicated1649144predicate__d
predicating1749654predicatin_g
predications17411174predications
predictions1649644prediction_s
predicts1339614predic____ts
predigests1443664predi__gests
preferments1844744pre_ferments
prejudgments2551844prejudgments
prepayments2053334pre_payments
presentments1654304presentments
presidents1347024presi__dents
pretreatments1752494pretreatments
prevalents1594974pre__valents
proficients1853414profic_ients
rearmaments1554254_rearmaments
recements13312284_re__cements
refinements1646794_refinements
regiments123910324_regi__ments
reindictments1862124_reindictments
remitments1446844_remi_tments
repigments1546344_repi_gments
retirements1357614_retirements
revilements1647134_revilements
rudiments1245824_rudi__ments
sediments1248214_sedi__ments
seducements1654494_seducements
traducements1752574traducements

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790508.79614187.1
3Display Results50500.0331515.2
 (SQL Overall)178691508.98519887.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.