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

155 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
repainting1312897(None) 
bepainting15144881bepainting
depainting14156151depainting
reprinting131510581reprinting
impainting1544502impainting
painting113614422__painting
preprinting1647412preprinting
rebaiting12311642rebai_ting
recanting122414822reca_nting
regaining112411082regain_ing
remaining122212792remain_ing
reminting122315102re_minting
repairing12310012repai_ring
repasting122312842repa_sting
repenting122316552rep_enting
repining114116592rep_in_ing
repinning12258972rep_inning
replanting1338522replanting
retaining102114732retain_ing
retinting102215252re_tinting
appointing1545323appointing
attainting1144783attainting
decanting132510633deca_nting
departing1349513depa_rting
depicting1537813dep_icting
detaining112510473detain_ing
fainting123312163__fainting
feinting123410833fe__inting
imprinting1546023imprinting
levanting1345523leva_nting
mispainting1645293mispainting
outpainting1445153outpainting
paining103920243__pain_ing
paintings12327103__paintings
panting104025423__pa_nting
pepsinating1645373pepsinating
pointing112813683__pointing
prepasting15168883prepa_sting
preplanting1645933preplanting
printing113216083__printing
raining83922693r__ain_ing
ranting84025413r__a_nting
reacting113317893re_a_cting
reanointing1244993reanointing
reappointing17122933reappointing
rebating112418343reba__ting
rebinding13249483re_binding
recaning111416693reca_n_ing
recasting122414233reca_sting
receipting1546753receipting
reciting113118073re_ci_ting
reclining121112283reclin_ing
recoining121313803recoin_ing
recounting1339193recounting
redacting13612303reda_cting
redating102620173reda__ting
redbaiting1446263redbai_ting
redlining111210293redlin_ing
reearning1039053reearn_ing
reediting11310953reedi_ting
reemitting1346633reemitting
refinding14259943re_finding
refining122416863re_fin_ing
refitting132811123re_fitting
refraining1437263refrain_ing
refronting1437273refronting
regranting1238323regranting
regrinding1335703regrinding
rehanging1437563reha_nging
rehinging1437453re_hinging
reigniting1246373reigniting
reining84425323re__in_ing
reinking13311023re__inking
rejoining17149223rejoin_ing
reknitting1584993reknitting
relanding112110923rela_nding
relating92725443rela__ting
relenting102716773re_lenting
relining93218743re_lin_ing
relinking1458253re_linking
relisting102414353re_listing
remailing122412473remai_ling
remanding132211143rema_nding
remanning12229033rema_nning
remating112322423rema__ting
reminding132311543re_minding
remitting122412623re_mitting
remounting1346673remounting
renailing102813333renai_ling
renting84026853re___nting
reorienting1246353reorienting
repacifying2243543repacifying
repacking1838283repa_cking
repaint9318363repaint___
repainted1277863repaint_ed
repaints1038483repaint__s
repaneling1345733repaneling
repapering1547043repapering
reparking1638923repa_rking
repassing12249423repa_ssing
repatching1844993repatching
repatriating1545453repatriating
repaving142810743repa__ving
repaying142712393repa__ying
repeating122618983rep_eating
replanning1345313replanning
replating122217403rep_lating
replicating1649093replicating
replotting1357043replotting
replunging1443953replunging
reporting12513903rep_orting
repositing13310493repositing
repotting12511123rep_otting
repricing14310473repri_cing
reprieving1644893reprieving
reprising12312553repri_sing
repudiating1546203repudiating
repugning1335863repugn_ing
reputing112412603rep__uting
requiting1939883requi_ting
reradiating1347263reradiating
reraising10313773rerai_sing
rerenting102617663re_renting
resailing103314253resai_ling
resaluting1137393resaluting
rescinding1436723rescinding
resenting102619293re_senting
reshining13310743reshin_ing
resifting133512093re_sifting
resinating11313733re_sinating
resining92919553re_sin_ing
resisting103215313re_sisting
resiting93521123re_si_ting
resitting103414873re_sitting
respiting121912863respi_ting
resplitting1444943resplitting
respringing1544583respringing
retailing103214733retai_ling
retaliating1248873retaliating
retasting102513413reta_sting
rethinking1845183rethinking
retraining11310243retrain_ing
retwisting1445633retwisting
reuniting10310693reuni_ting
rewinding14238933re_winding
rewinning13257443re_winning
rewriting13310413rewri_ting
sainting93215733__sainting
separating1348643separating
splinting1238193_splinting
sprinting12310033_sprinting
tainting93613583__tainting
tenanting1036213tena_nting
trepanning1344153trepa_nning
trephining1644933trephin_ing

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 Filter1786911406030.403443402.0
2DLD Change Limit1406031556.66021111.6
3Display Results1551550.0762039.5
 (SQL Overall)1786911557.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.