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

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

74 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
resplicing154629(None) 
preslicing1546362pres_licing
replacing142210162re_placing
repricing14310472re_pricing
respacing1438892resp_acing
respiring12159902resp_iring
respiting121912862resp_iting
resplitting1444942resplitting
splicing1338962__splicing
besliming1435493bes_liming
despairing1445063despairing
despising13167503desp_ising
despiting13179323desp_iting
despoiling1445113despoiling
displacing1646413displacing
emplacing1645483_emplacing
misplacing1745913misplacing
mispricing1746713mispricing
preplacing1746003pre_placing
prepricing1746733pre_pricing
realising10313173re_alising
realizing19313813re_alizing
reclining121112283re_clining
redlining111210293re_dlining
rejoicing19136943re_joicing
relacing112516043re__lacing
relining93218743re__lining
reliving122713343re__living
repairing12310013re_pairing
repining114116593re_p_ining
replating122217403re_plating
replaying15259603re_playing
replicating1649093re_plicating
replicon1244323re_plicon_
replicons1344093re_plicons
replowing1537413re_plowing
replying14269403re_pl_ying
reprising12312553re_prising
resailing103314253res_ailing
resaluting1137393resaluting
reseizing19311233res_eizing
reselecting1446023reselecting
reselling102213833resel_ling
reservicing1753423reservicing
reshining13310743res_hining
residing103015473res__iding
resiling93520173res__iling
resining92919553res__ining
resiting93521123res__iting
resizing182714163res__izing
reslating102516993res_lating
resoling92916303resol__ing
resolving1337743resol_ving
respading1338803resp_ading
respeaking1736803respeaking
respecting1549883respecting
respelling1347973respelling
resplice1237253resplic__e
respliced1445543resplic_ed
resplices1336623resplic_es
responding1437403responding
respooling1355743respooling
respotting1347113respotting
respraying1636093respraying
respring111614063resp__ring
respringing1544583respringing
restricting1449303restricting
restriking1548043restriking
restriving1448133restriving
resulting10311083resul_ting
revoicing15117713re_voicing
slicing103514643__s_licing
spicing123914533__sp_icing
splining11310773__splining

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 Filter1786911406030.420425454.8
2DLD Change Limit140603746.56321423.6
3Display Results74740.0302466.7
 (SQL Overall)178691747.01325480.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.