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

108 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
resplices133662(None) 
resplice1237251resplice_
respliced1445541respliced
preslices1338212pres_lices
replaces123114122re_places
replicas1237092re_plicas
replies94521042re_pli_es
reprices122913352re_prices
respaces12311042resp_aces
respires10311902resp_ires
respites10513242resp_ites
resplits1037722respli_ts
splices113914382__splices
aruspices1343353arusp_ices
auspices1236443ausp_ices
beslimes1246953bes_limes
complices1739253complices
despises1139433desp_ises
despites11410313desp_ites
displaces1448593displaces
emplaces1438413_emplaces
espies83716803_esp_i_es
helices12313723he__lices
hospices1587633hosp_ices
misplaces1537953misplaces
misprices1547913misprices
preplaces1578753pre_places
preprices1569263pre_prices
preslice1258623pres_lice_
presliced1435983pres_liced
realises82420183re_alises
realizes173116843re_alizes
reapplies1344913reappli_es
reclines103718543re_clines
rectrices1338873rectrices
redlines93916083re_dlines
reflies104418533re_fli_es
rejoices17287663re_joices
relaces93420883re__laces
relics84517903re__lic_s
relicts94414593re__licts
relies65036423re__li_es
relines75331323re__lines
relives104619443re__lives
repines94927383re_p_ines
replace113214283re_place_
replaced133211403re_placed
replacer12279743re_placer
replacers13266833re_placers
replates102919273re_plates
repletes102812473re_pletes
replica1137943re_plic_a
replicase1344803re_plicase
replicases1444673re_plicases
replicates1449453re_plicates
replicon1244323re_plicon
replicons1344093re_plicons
replied103914453re_pli_ed
replier94214973re_pli_er
repliers103710163re_pliers
reprice113212833re_price_
repriced132610543re_priced
reprises102615463re_prises
reptiles103913063re_ptiles
resales74724903resal__es
resalutes947433resalutes
reseizes1759853res_eizes
reselects1156413reselects
reservices1544893reservices
reshines112615443res_hines
resides84523283res__ides
resiles74026543res__iles
resiliences1375243resiliences
resilins83013373resili_ns
resites74027793res__ites
resizes164216843res__izes
reslates83619503res_lates
resoles73823653resol__es
resolutes968193resolutes
resolves113010783resol_ves
resources1146203resources
respace11310913resp_ace_
respaced1338503resp_aced
respades1139853resp_ades
respects1247703resp_ects
respire9411543resp_ire_
respired1148993resp_ired
respite9513033resp_ite_
respited11410813resp_ited
resplicing1546293resplicing
resplit9310373respli__t
responses1147453responses
resprings12156253resprings
restricts1138823restricts
restrikes1339413restrikes
restrives12310663restrives
resupplies1442413resuppli_es
revoices13278993re_voices
semplice1447013semplice_
simplices1546043simplices
slices84022853__s_lices
spices104326033__sp_ices
splice104915103__splice_
spliced124310593__spliced
splicer114710523__splicer
splicers12338113__splicers
splines94718893__splines
surplices1346043surplices

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411087.42320024.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.87522690.9
 
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.