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

60 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
promisor1226618(None) 
promiser122510671promiser
promisors13236361promisors
previsor13116302previsor
promise113415842promis_e
promised133010872promised
promisee122711332promisee
promisers13268202promisers
promises122916762promises
promissory1752772promissory
proviso1237312proviso_
provisory1744352provisory
provisos1336912provisos
atomiser10268153atomiser
bromism1337623bromis_m
bromisms1436403bromisms
improvisor1782763improvisor
poiser84217243p_o_iser
poison8312223p_o_ison
praiser93413943pr_aiser
preciser123411663preciser
premier113515633premi_er
premise113818553premis_e
premised133013193premised
premises123018273premises
premiss113513813premis_s
pressor93512883pr_essor
previsors14126483previsors
prior74316173pr__i_or
prison8514023pr__ison
processor1346233processor
proctor11310433pro_ctor
professor1445033professor
profiler13287643profiler
profiter132710203profiter
prolabor1284543prolabor
prolusory1442833prolusory
promine112819443promi_ne
promines123018803promines
promisees13246863promisees
promising14410973promising
promo95620003prom__o_
promos105116423prom__os
promoter12311453promoter
prompter1437983prompter
proms95426413prom_s__
pronator10311783pronator
proposer121810633proposer
proser84223463pro__ser
prosier93817483prosi_er
proso77222413pro__so_
prosos85718553pro__sos
protestor11178493protestor
protist9320223protis_t
protists10313363protists
provider1436703provider
provision1447633provision
provisoes1446653provisoes
proximo1845143proximo_
revisor10388733_revisor

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 Filter1786911461620.406440125.6
2DLD Change Limit146162607.70318974.7
3Display Results60600.0163750.0
 (SQL Overall)178691608.12521992.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.