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

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

100 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
presignalling176111(None) 
presignaling1652851presigna_ling
presignalled1651443presignall_ed
presignifying2351793presignifying
signalling1243803___signalling
designating1446074_designa_ting
prebilling1595414prebi___lling
predesignating1962554predesigna_ting
prefinancing2051944prefi_nancing
preselling1338694pres___elling
presignal12105554presigna_l___
presignaled1552384presigna_l_ed
presignals1363844presigna_l__s
redialling1246204_redi__alling
resigning1139464_resign___ing
resinating11313734_resi_na_ting
signaling1136564___signa_ling
begalling13216495_be__g_alling
crenelling1345685cre___nelling
designing1236625_design___ing
forestalling1653635fores__talling
pedalling1346665p_e___dalling
pedestalling1652565p_edestalling
pepsinating1645375pepsi_na_ting
perilling12410005p_eri___lling
personalising1693545pers_onalising
personalizing2575085pers_onalizing
personating1447675pers_ona_ting
pinballing1544015p___inballing
pinnacling1543065p___innacling
preassigning1652925preassign___ing
prebinding1696165prebi_n__ding
precanceling1952775pre_canceling
precancelling2051745precancelling
prechilling1943745pre__chilling
predicating1749655predi_ca_ting
predigesting1753685predig_esting
predrilling1543675pre__drilling
preenacting16125375pre__enacting
prefiguring1842935prefig__uring
prefiling1549535prefi____ling
prehandling1853425pre_han_dling
preinviting1744365pre_i_nviting
prerinsing1347645preri_n__sing
presaging1339395pres___a_ging
prescheduling2261105prescheduling
prescinding1744855prescin__ding
presenting131013025pres_en__ting
presettling1444455pres__ettling
preshaping1845425pres__ha_ping
presiding13510905presi____ding
presifting1638085presi___fting
presignified1952445presign_ified
presignifies1852705presign_ifies
presignify1952435presign___ify
presoaking1736255pres__oa_king
presolving1644365pres___olving
pressgang1342775pressg_a___ng
prestamping1863655pres__tamping
pretelling1338145pre___telling
prevailing1656725pre___vailing
prevaluing1644275pre___valuing
prilling113413415pr__i___lling
princeling1544655pr__i_nceling
rebilling12228835_rebi___lling
recalling122211905_re___calling
redialing11311845_redi__a_ling
redistilling1453305_redistilling
refalling132010425_re___falling
refilling13299335_refi___lling
refinancing1742835_refi_nancing
regaling10315365_re__g_a_ling
regionalizing2454615_regionalizing
reigning1039885_re_ign___ing
reigniting1246375_re_ign_iting
reinstalling1373395_reinstalling
rekindling1643525_reki_n_dling
remigrating1547595_remigra_ting
renailing102813335_re___nailing
repanelling1443475_re_panelling
resailing103314255_res___ailing
rescaling122212015_res__ca_ling
resealing102115675_res__ea_ling
reselling102213835_res___elling
reshingling1642395_reshin_gling
resighting1546075_resig__hting
resignation1247475_resigna_tion
resignations1346885_resignations
resiling93520175_resi____ling
resinifying1844355_resi_nifying
resining92919555_resi_n___ing
resituating1247545_resitua_ting
resonating11311265_res_ona_ting
respelling1347975_res__pelling
restabling1337655_res__tabling
retotalling1244045_re_totalling
revictualling1961145_revictualling
rivalling1335965_r__i_valling
signalising1344165___signalising
signalizing2245975___signalizing

Search took 10 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.423422437.4
2DLD Change Limit1247901009.36013332.3
3Display Results1001000.0601666.7
 (SQL Overall)1786911009.84318154.1
 
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.