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

31 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
procaryotes185244(None) 
procaryote1752701procaryote_
prokaryotes2051731prokaryotes
prokaryote1951892prokaryote_
eucaryotes1552313_eucaryotes
procreates1448153proc_reates
prokaryotic2281783prokaryotic
eucaryote1452464_eucaryote_
eukaryotes1751664_eukaryotes
precarious1445504precario_us
probates12414284proba___tes
procaines13311524proca__ines
procarps1445974procar___ps
procercoids1852134procercoids
procreate1348144proc_reate_
procreated1546444proc_reated
procryptic2153244proc_ryptic
procurators1545174procurators
procures1239214procur___es
procuresses1543814procuresses
prodromes1446064pro_dr_omes
promotes12314124pro___motes
pronates10418374prona___tes
pronatores1247374prona_tores
propagates1556144propa_gates
prorates10418074pro__r_ates
proselytes1544744prosely_tes
prostrates12411994prostr_ates
rocamboles1652304_rocamboles
rockroses1545564_rockr_oses
urochromes1754204urochr_omes

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 Filter1786911488190.466383457.1
2DLD Change Limit148819318.86016796.7
3Display Results31310.0161937.5
 (SQL Overall)178691319.34219127.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.