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 “portance” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
portance1231011(None) 
portances1349831portances
importance1654782importance
parlance1248722parlance
pittance1246112pittance
portable12313202portable
portage103013642porta_ge
potence11711362po_tence
prance104318572p_r_ance
acutance1246303acutance
aortae65115473aorta__e
borane84620213bor_an_e
distance11311853distance
dormancy1644423dormancy
durance1059113dur_ance
entrance10311323entrance
fortalice1445773fortalice
fortune1068303fortun_e
importances1754293importances
importancy1953523importancy
instance1049873instance
joyance1944773jo_yance
laitance1045973laitance
montane91313623montan_e
mordancy1644193mordancy
mortice11711493mort_ice
nondance1148233nondance
normande1145933normande
octane81411633_octan_e
orange74016323_or_ange
ordnance1144833_ordnance
outdance11238733_outdance
outrance102212773_outrance
parlances1348953parlances
parlante1039693parlante
partake1339643parta_ke
partan83820563partan__
partans94418283partan_s
penance11313443p_enance
pentane9415743pentan_e
perchance1866393perchance
permeance1545913permeance
phytane1545443phytan_e
piquance2144213piquance
pittances1345703pittances
platane93112303platan_e
poignance1443593poignance
pomace123111913po_ma_ce
ponce95222513po___nce
pontine92419053pontin_e
porcine11312843porcin_e
portables1337873portables
portably1539313portably
portaged12228463portaged
portages112613223portages
portal84218463porta__l
portaled11239203portaled
portals94015563porta_ls
portapack1951813portapack
portapak1642343portapak
portative1449373portative
portend103411193porten_d
portended1345643portended
portends11358963portends
portent93619643porten_t
portents103512823portents
porthole1349523porthole
portico11310143port_ico
portiere1038773portiere
porting103021783portin_g
portside1138163portside
postage103214853posta_ge
postanal1048053postanal
postface1566123postface
postrace12310533postrace
potable112115363po_table
potage92715903po_ta_ge
potences12710693po_tences
potency1457433po_tency
pottage103310603potta_ge
pounce105214093po__unce
poutine93316823poutin_e
pranced123714043p_r_anced
prancer113613383p_r_ancer
prances113618773p_r_ances
pretence122312123pretence
prince104114763p_r_ince
profane122111863profan_e
propane112716153propan_e
province1546923province
pursuance1344093pursuance
purtenance1454053purtenance
rance75028513__r_ance
romance11311083ro_mance
sonance9310313so_nance
sortable10312483sortable
soutane7312063soutan_e
stance84316913__stance
trance84718763_tr_ance
variance1397413variance
voidance1444723voidance

Search took 8 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.436409841.7
2DLD Change Limit1461621017.20320291.8
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.68523251.9
 
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.