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

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

102 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
outpreaching204234(None) 
outreaching1744911out_reaching
upreaching1844112_u_preaching
outcoaching1943443out_coaching
outdreaming1544233outdrea_ming
outpacing1478363outp__ac_ing
outpitching1962973outp_itching
outplacing1546193outp_lac_ing
outpraying1646523outpr_a_ying
outpreach1642703outpreach___
outpreached1942433outpreach_ed
outpreaches1842403outpreach_es
outpreening1444193outpre_ening
outpressing1485973outpre_ssing
outpricing1547003outpr_ic_ing
outpunching1942643outp_unching
outracing12912163out_r_ac_ing
outreading1239283out_rea_ding
outspreading1652713outsprea_ding
outstretching1961153outstretching
overreaching2175173overreaching
preaching172811163___preaching
approaching2162454_approaching
breaching17269404___breaching
entrenching1743354ent_renching
forereaching2151954forereaching
impeaching2043374_imp_eaching
intrenching1744074int_renching
nonteaching1753584nont__eaching
outacting1239214out___acting
outbeaming1546044out_bea_ming
outbitching1992864out_bitching
outbleating1444884outblea_ting
outbragging1643724outbr_agging
outbraving1646164outbr_a_ving
outbrawling1743704outbr_awling
outbreeding1554344outbre_eding
outcatching1943114out_catching
outcheating1744874outchea_ting
outcrawling1743654outcr_awling
outdragging1543434outdr_agging
outdrawing1546024outdr_a_wing
outdressing13104784outdre_ssing
outearning1146744out__earning
outeating10814494out__ea_ting
outechoing1644624out__e_choing
outfacing1578114out__fac_ing
outfeasting1543844out_feasting
outfencing1645294out_fenc_ing
outgleaming1542534outglea_ming
outhearing1438444out_hea_ring
outleading1237134out_lea_ding
outleaping1346204out_lea_ping
outlearning1243544out_learning
outmarching1943604out_marching
outmatching1943334out_matching
outpassing1355854outp__assing
outpeopling1653174outp_eopling
outplanning1463834outp_lanning
outplaying1645964outp_la_ying
outproducing1852564outproducing
outpromising1752424outpromising
outpushing1644774outp__ushing
outraging111010884out_r_a_ging
outraising1139904out_r_aising
outranging1238004out_r_anging
outranking1537674out_r_anking
outrating10916404out_r_a_ting
outraving13910134out_r_a_ving
outreach1346004out_reach___
outreached1645004out_reach_ed
outreaches1545354out_reach_es
outreasoning1352134out_reasoning
outroaring1138834out_roa_ring
outrocking1747054out_r_ocking
outrushing1446404out_r_ushing
outscreaming1752194outscrea_ming
outspeaking1844174outspea_king
outswearing1544074outswea_ring
outtrading1247154outtr_a_ding
outtricking1844144outtr_icking
outwatching2043014out_watching
outwearing1437184out_wea_ring
outwearying1843204out_wearying
outweighing1942744out_weighing
outwrestling1651694outwrestling
overreacting1856664overreacting
overteaching2174924overteaching
peaching163613644___p_eaching
pleaching17257084___pleaching
preacting142412534___preacting
reaching143317204____reaching
reproaching1944304_reproaching
reteaching1636024ret__eaching
retrenching1743924ret_renching
stretching1645814_st_retching
teaching143612604__t__eaching
trenching15227654__t_renching
unbreeching1942164_unbreeching
unteaching1645494_u_nteaching
unwreathing1842804_unwreathing
uprearing1238374_u_prea_ring

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901026.83018270.9
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.26624592.8
 
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.