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

125 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
resmelting133726(None) 
remelting12311701re_melting
remeeting12311432re_meeting
reseating102421532res_eating
resecting122816482res_ecting
reselling102213832res_elling
resenting102619292res_enting
resetting102816292res_etting
respecting1549882respecting
respelling1347972respelling
resulting10311082res_ulting
smelting11339712__smelting
besetting12268423bes_etting
besmearing1544323besmearing
besmiling1436263besmil_ing
besmutting1553353besmutting
cementing1438763ce_menting
dementing13311043de_menting
desalting1138843des_alting
deserting11713143des_erting
fermenting1646823fermenting
helmeting1545503helme_ting
melting103317753___melting
mismeeting1546243mismeeting
overmelting1768113overmelting
permeating1539923permeating
preselling1338693pres_elling
presenting131013023pres_enting
presetting131010833pres_etting
reasserting1246153reasserting
rebelling122111163re_belling
recementing1645223recementing
recreating131214583recreating
reejecting2045813reejecting
reelecting1338783reelecting
reeling83126863re__el_ing
reemerging1474583reemerging
reemitting1346633reemitting
reerecting1339973reerecting
reesting93118273re__esting
refecting152413353re_fecting
refeeling13229313refeel_ing
refelling132211313re_felling
reflecting1638823reflecting
refueling13227973refuel_ing
refuelling1474973refuelling
regelating1239953re_gelating
regimenting1544663regimenting
regreeting1237343regreeting
regretting1237783regretting
reheating132314913re_heating
reheeling13218263reheel_ing
rejecting192211153re_jecting
relenting102716773re_lenting
reletting102713943re_letting
remating112322413re_m_ating
remedying1635143re_medying
remending132311313re_mending
remerging1358323re_merging
reminting122315103re_minting
remitting122412623re_mitting
remolding1338163re_molding
renesting102514703re_nesting
repeating122618983re_peating
repelling122312753re_pelling
repenting122316553re_penting
requesting2046313requesting
rerenting102617663re_renting
resailing103314253resail_ing
resaluting1137393resaluting
resampling1544333resampl_ing
rescaling122212013rescal_ing
resculpting1643453resculpting
resealing102115673res_ealing
reseeding112410493res_eeding
reseeing92412623res_e_eing
reseeking14208493res_eeking
reseizing19311233res_eizing
reselecting1446023reselecting
resembling1544733resembling
resending112313363res_ending
reserving131110643res_erving
resettling1135893res_ettling
resewing122712263res_e_wing
reshooting1436223reshooting
resifting133512093res_ifting
resighting1546073resighting
resiling93520173res_il_ing
resinating11313733resinating
resisting103215313res_isting
resiting93521123res__iting
resitting103414873res_itting
reslating102516993res_lating
resmelt9411773resmelt___
resmelted1236033resmelt_ed
resmelts1046143resmelt__s
resmoothing17122593resmoothing
resoling92916303res_ol_ing
resolving1337743res_olving
resonating11311263resonating
resorting10614613res_orting
respeaking1736803respeaking
respellings1442683respellings
respiting121912863res_piting
respotting1347113respotting
restarting11310663restarting
restating102319413res_tating
resting85031183res___ting
restyling1337923restyl_ing
retelling102112493re_telling
retesting102614603re_testing
retreating111414773retreating
reveling123117083re_vel_ing
revelling132412553re_velling
reverting132315133re_verting
revesting132814123re_vesting
revetting132912633re_vetting
revolting1339633re_volting
rewelding1436913re_welding
rewetting132710443re_wetting
russeting1065323russe_ting
russetting1184253russetting
segmenting1445003segmenting
smelling113712723__smelling
tesselating1243843tesselating

Search took 7 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.406440125.6
2DLD Change Limit1406031255.75024452.7
3Display Results1251250.0631984.1
 (SQL Overall)1786911256.21928733.1
 
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.