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

81 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
promisees1324686(None) 
promisee122711331promisee_
promisers13268201promisers
promises122916761promis_es
premises123018272premis_es
premisses13288762premisses
promines123018802promi_nes
promise113415842promis_e_
promised133010872promis_ed
promiser122510672promis_er
promisors13236362promisors
provisoes1446652provisoes
atomisers11255453atomisers
atomises103514403atomis_es
bromides13219363bromi_des
bromines122514253bromi_nes
bromisms1436403bromis_ms
bromizes21258333bromi_zes
frisees104411693fr__isees
nominees1037363_nominees
pharisees1444633pharisees
poisers94214433p_o_isers
poises84226543p_o_is_es
polishes13711783p_olishes
praisers103410833pr_aisers
praises94121103pr_ais_es
praxises1739063praxis_es
precises123218333precis_es
premieres13288233premieres
premiers122911653premi_ers
premies113823063premi__es
premise113818553premis_e_
premised133013193premis_ed
premiss113513813premis__s
premixes193110083premi_xes
previses133814283previs_es
primines123013703primi_nes
primuses1237083primus_es
priseres10310823pr__iseres
prises84133173pr__is_es
prisses94816713pr__isses
probities13312653probities
processes13310233processes
proclises1339543proclis_es
prodigies1346953prodigies
professes1437873professes
profilers14236293profilers
profiles133211233profi_les
profiteer14274493profiteer
profiteers15213693profiteers
profiters14228313profiters
prolines102619693proli_nes
promine112819443promi_ne_
prominences1744863prominences
prominent1349573prominent
promising14410973promising
promisor12266183promis_or
promoters13310093promoters
promotes12314123prom_otes
prompters1537553prompters
promulges1443383promulges
propines122618933propi_nes
proposers13228523proposers
proposes122515973propos_es
prosers94219643pro__sers
proses84733473pro__s_es
prosiness11311683prosiness
prosses94019513pro__sses
prossies101515223pro_ssies
protases102115033protas_es
protegees1275393protegees
protheses1449073protheses
protists10313363protis_ts
providers1535593providers
provides1439883provi_des
provinces1646853provinces
provisos1336913provis_os
prowesses1437193prowesses
proxies163014933proxi__es
pyrosises1457583pyrosis_es
remises93423483_remis_es

Search took 7 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.423422437.4
2DLD Change Limit148641816.39023261.5
3Display Results81810.0302700.0
 (SQL Overall)178691816.84326113.0
 
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.