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

82 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
provinces164685(None) 
province1546921province_
princes113015142pr__inces
prolines102619692prolin_es
promines123018802promin_es
propines122618932propin_es
providences1953822providences
provides1439882provi_des
provisoes1446652provisoes
bovines12412663_bovin_es
bromines122514253bromin_es
convinces1647833convinces
crevices1536713crevi_ces
evinces1237803__evinces
frounces1336183fro_unces
novices1238223_novi_ces
ovines94614343__ovin_es
pointes93216753p_o_intes
polices113118053p_oli_ces
ponces104720843p_o__nces
portances1349833portances
potences12710693p_otences
pounces114113893p_o_unces
pralines102217723pralin_es
prances113618773pr__ances
precincts1544993precincts
prerinses1138813prerinses
presences132113793presences
pretences132312613pretences
previses133814283previ_ses
prices104524543pr__i_ces
primines123013703primin_es
prince104114763pr__ince_
princess12266803pr__incess
privies122414263privi__es
privities14312033privities
probities13312653probities
procaines13311523procain_es
prodigies1346953prodigies
produces1347903pro_duces
profanes132311573profan_es
profiles133211233profi_les
progenies12314123progenies
proline92321593prolin_e_
prolonges12337923prolonges
promine112819443promin_e_
prominences1744863prominences
promisees13246863promisees
promises122916763promi_ses
pronounces1454993pronounces
propanes122415823propan_es
propenes122816513propen_es
propine113020213propin_e_
propined133111503propin_ed
propones122516963propon_es
prosiness11311683prosiness
provenances1854533provenances
provender1544893provender
provenders1644273provenders
proveniences1953673proveniences
proves114322253prov___es
provide1339853provi_de_
provided1536843provi_ded
providence1854093providence_
provider1436703provi_der
providers1535593providers
provincial1754013provincial
provincials1852943provincials
proving134214073provin__g
provirus1345453provi_rus
proviruses1554513proviruses
provisos1336913provi_sos
provokes1776603prov_okes
proxies163014933proxi__es
prudences1446683prudences
pruriences1444703pruriences
pyronines1458323pyronin_es
ravines104220233_ravin_es
romances12310793_romances
rovings11439493_rovin_gs
tropines102214923tropin_es
trounces1037063tro_unces

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641829.47015696.0
3Display Results82820.0302733.3
 (SQL Overall)178691829.65618505.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.