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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
prelaunches185223(None) 
prelaunched1951921prelaunched
relaunches1543441_relaunches
prelaunch1642152prelaunch__
prepunches1954012pre_punches
relaunched1642682_relaunched
craunches1655723cr__aunches
launches1387903___launches
paunches1568173p___aunches
planches153111863p__la_nches
preaches153214893pre_a__ches
prelacies13310053prela__cies
prelaunching2051503prelaunching
prelunch1543433prel_unch__
preluncheon185883prel_uncheon
prepunched2073113pre_punched
raunches1368053_r__aunches
relaunch1352803_relaunch__
revanches1746253_reva_nches
avalanches18102844avala_nches
blanches153311604__bla_nches
branches153613804br__a_nches
breaches153714124bre_a__ches
brunches153710454br___unches
cranches153114544cr__a_nches
craunched1764024cr__aunched
crunches153711354cr___unches
debauches17124064_debau_ches
drenches14309804dre___nches
freelances1545224freela_nc_es
frenches163311634fre___nches
glunches1436264__gl_unches
haunches1656964___haunches
keypunches2451524_keypunches
launces9329004___launc_es
launched1475404___launched
launcher1365564___launcher
launchers1454334___launchers
lunches124115444___l_unches
painches1588914p___ainches
parlances1348954parla_nc_es
paunched1645524p___aunched
peaches144120054p_e_a__ches
peduncles1443644p_e_duncles
penances12312444p_ena_nc_es
penuches1536944p_e_nu_ches
planche14299754p__la_nche_
planchet152511964p__la_nchet
planchets16236744p__la_nchets
pleaches153210434ple_a__ches
plenches153110624p__l_enches
potlaches16115264potla__ches
potlatches17113324potla_tches
prances113618774pr__a_nc_es
preached163412064pre_a__ched
preacher153211374pre_a__cher
preachers16339574pre_a__chers
precancel1546204preca_nc_el
precancels1644064preca_ncels
precancer1547094preca_nc_er
precancers1645254preca_ncers
prefaces15311064prefa__c_es
pregnancies1644564pregnancies
prehandles1644184preha_ndles
prelates10418574prela___tes
prelatures1245724prela_tures
preludes1137834prel_u__des
preplaces1578754prepla__c_es
prepuces1438584pre_pu_c_es
prepunch1743644pre_punch__
presences132113794pre_senc_es
pretences132312614pre_tenc_es
preunites1138934pre__unites
prevalences1845094prevalenc_es
prewashes1744754prewa__shes
pronounces1454994pronounc_es
punches144816134p____unches
ranches123620114_r__a_nches
reaches123423204_re_a__ches
rebranches1745194_rebranches
relaces93420884_rela__c_es
relaunching1742244_relaunching
relaunder1053704_relaun_der
relaunders1153104_relaunders
reliances1139624_relianc_es
rematches1636654_rema_tches
renounces1147544_renounc_es
repatches1636714_repa_tches
retouches1445904_retou_ches
retrenches1545904_retrenches
revanche1645004_reva_nche_
staunches1444604__staunches
tranches132915514tr__a_nches
trenches133512604tre___nches
upreaches1654634upre_a__ches
wrenches163210234wre___nches

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819968.48617537.0
3Display Results96960.0462087.0
 (SQL Overall)178691968.95219961.0
 
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.