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

172 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
repainted127786(None) 
bepainted1484341bepainted
depainted1375841depainted
reprinted1289041reprinted
impainted1454772impainted
painted104214632__painted
preprinted1546542preprinted
rebaited11410542rebai_ted
recanted112513512reca_nted
regained102111242regain_ed
remained112412892remain_ed
reminted113615082re_minted
repaint9318362repaint__
repaints1038482repaint_s
repaired1148952repai_red
repasted112611532repa_sted
repented112614982rep_ented
repined104918772rep_in_ed
repinned1157472rep_inned
replanted1248062replanted
reprinter1197352reprinter
retained93016092retain_ed
retinted94414362re_tinted
unpainted1237182unpainted
appointed1444803appointed
attainted1044693attainted
bepaint11312183bepaint__
bepaints1235113bepaint_s
decanted122310493deca_nted
depaint10314593depaint__
depaints1136643depaint_s
departed1238823depa_rted
depicted1437743dep_icted
detained103111643detain_ed
fainted114211723__fainted
feinted11379623fe__inted
imprinted1445753imprinted
levanted1245323leva_nted
mispainted1545013mispainted
outpainted1344323outpainted
pained95622853__pain_ed
painter93814563__painter
panted95024823__pa_nted
pepsinated1545233pepsinated
pointed103813983__pointed
prepasted14137673prepa_sted
printed104016373__printed
rained75024603r__ain_ed
ranted74324703r__a_nted
reacted103015713re_a_cted
reanointed1144553reanointed
reappointed1652943reappointed
rebated103619703reba__ted
recaned102817203reca_n_ed
recanter101913153reca_nter
receipted1445353receipted
recited104319103re_ci_ted
reclined113613603reclin_ed
recoined113614433recoin_ed
recounted1238723recounted
redacted12410243reda_cted
redated93120923reda__ted
redbaited1344713redbai_ted
redlined103811233redlin_ed
reearned948893reearn_ed
reedited10310083reedi_ted
reemitted1245943reemitted
refined114720003re_fin_ed
refitted12309413re_fitted
refrained1347223refrain_ed
refronted1336063refronted
regainer9249353regain_er
regranted1137703regranted
rehanged1357833reha_nged
rehinged1336853re_hinged
reignited1145683reignited
reined74425523re__in_ed
reinked1239793re__inked
reinter73116843re__inter
rejoined16318593rejoin_ed
reknitted1444023reknitted
relanded102410463rela_nded
related83327573rela__ted
relented92614943re_lented
relined85321933re_lin_ed
relinked1337003re_linked
relisted9312623re_listed
remailed112411403remai_led
remainder1244683remainder
remanded123011323rema_nded
remanned11319353rema_nned
remated103522473rema__ted
reminded123411523re_minded
remitted113312073re_mitted
remounted1236283remounted
renailed92512803renai_led
rented74426593re___nted
reoriented1145343reoriented
repacified1844893repacified
repacked17188743repa_cked
repaid94716323repai___d
repainting13128973repainting
repairer1036783repai_rer
repairmen1343333repairmen
repand95316063repa_n__d
repanel939963repa_n_el
repaneled1245333repaneled
repapered1445233repapered
reparked15208923repa_rked
repartee10312763repa_rtee
repassed11229273repa_ssed
repatched1745313repatched
repatriated14114893repatriated
repaved133311133repa__ved
repeated113117443rep_eated
repenter102813863rep_enter
repine85627813rep_in_e_
repiner94816903rep_in_er
repines94927383rep_in_es
replanned1235163replanned
replated112817523rep_lated
replicated1548773replicated
replied103914463repli__ed
replotted1235823replotted
replunged1343383replunged
reported11312703rep_orted
reposited1239143reposited
repotted1139283rep_otted
repriced132610543repri_ced
reprieved1584873reprieved
reprint9318983reprint__
reprinters1295793reprinters
reprints1039903reprint_s
reprised112012213repri_sed
repudiated1445443repudiated
repugned1235363repugn_ed
reputed104613483rep__uted
requited18169723requi_ted
reradiated12177533reradiated
reraised9312363rerai_sed
rerented92516163re_rented
resailed93613063resai_led
resaluted1046473resaluted
rescinded1335763rescinded
resented92716963re_sented
reshined123011123reshin_ed
resifted12310153re_sifted
resinated10413283re_sinated
resined84522653re_sin_ed
resisted9312693re_sisted
resited85122423re_si_ted
respited11410813respi_ted
retailed94113963retai_led
retainer82913813retain_er
retaliated1148443retaliated
retasted92412113reta_sted
retinued95210823re_tinued
retrained10411313retrain_ed
retwisted1344893retwisted
reunited939713reuni_ted
rewinded13277673re_winded
sainted84114243__sainted
separated1237713separated
splinted11369253_splinted
sprinted113411163_sprinted
tainted83512423__tainted
tenanted937043tena_nted
trepanned1243913trepa_nned
trephined1544903trephin_ed
unpointed1237153unpointed
unprinted1238133unprinted
untainted1038423untainted

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411726.95621368.7
3Display Results1721720.0602866.7
 (SQL Overall)1786911727.46923924.4
 
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.