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

166 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
resplit931037(None) 
presplit1247751presplit
resplits1037721resplits
esprit8312842_esprit
relit55340682re__lit
replot83818592re_plot
resilin72913972resilin
resit54241042res__it
respect11412032respect
respelt9312142respelt
respite9513032resp_ite
resplice1237252resplice
respot83117632resp_ot
result6318222resul_t
split75729012__split
unsplit956562unsplit
cesspit1145463cesspit
cresylic1543083cresylic
desalt7518313desal_t
despair1045463despair
despite10410123desp_ite
despoil1046523despoil
despot93413293desp_ot
esprits938393_esprits
exploit1648623_exploit
gaslit7513503gas_lit
greenlit945803greenlit
jesuit1339583jes_uit
mesquit18387953mesquit
mislit83019693mis_lit
readmit1039823readmit
realia6314593re_alia
realist73225383re_alist
reality10313573re_ality
reallot7312133reallot
rebait8320403re_bait
rebuilt939973rebuilt
recit75235103re__cit
recruit939773recruit
redbait1039803redbait
reedit7617223re_edit
reemit8717223re_emit
reenlist8410363reenlist
refelt94521423refel_t
refit84230063re__fit
reflet94024233re_flet
regalia839223regalia
regality1249313regality
regilt71217493regil_t
reglet73724233re_glet
regolith1247543regolith
reguli738143reguli_
reknit10312533re_knit
relet54749823re__let
relic74623363re__lic
relict83623903re__lict
relist64628413re__list
remelt85123123remel_t
remit75737223re__mit
repaid94716323re_paid
repaint9318363re_paint
repair84011463re_pair
repast83520633re_past
repeat85127213re_peat
repent84728873re_pent
repin75324703re_p_in
replan83215823re_plan
replant93318533re_plant
replate93420053re_plate
replay113412923re_play
repled93319773re_pled
replete92912983re_plete
replica1137943re_plica
replied103914443re_plied
replier94214973re_plier
replies94521043re_plies
replots93412633re_plots
replow114210343re_plow
reply104015853re_pl_y
report85326013re_port
reposit9315863reposit
repot75132623re_p_ot
reprint9318983re_print
resaid74517083res_aid
resail64418733res_ail
resails74616743resails
resale64025543resal_e
resales74724903resales
resalute857413resalute
resat55139683res__at
rescript1277423rescript
resculpt1245323resculpt
reseat64131493res_eat
resect84424703res_ect
reselect1059943reselect
resell64215203resel_l
resells73313203resells
resent63833623res_ent
reset55051863res__et
reship11310673res_hip
reshoot102513893reshoot
reshot93519633res_hot
resid64124093res__id
resift94017723res_ift
resight11510643resight
resile64627673resil_e
resiled84621983resiled
resiles74026543resiles
resilient9410113resilient
resiling93520173resiling
resilins83013373resilins
resin54131053res__in
resist64524533res_ist
resite64128453res__ite
resits64725563res__its
reslate73520593res_late
resmelt9411773resmelt
resojet14312823resojet
resold73915363resol_d
resole64624183resol_e
resoled84119283resoled
resoles73823653resoles
resoling92916303resoling
resolute868513resolute
resolve103910983resolve
resort65728613res_ort
respace11310913respace
respade1039573respade
respeak1335933respeak
respects1247703respects
respell947023respell
respells1056333respells
respire9411543respire
respited11410813resp_ited
respites10513243resp_ites
respliced1445533respliced
resplices1336623resplices
respoke134311283respoke
respond1039113respond
respool937633respool
respots92912763respots
respray1236503respray
respring111614063respring
resprout1078783resprout
rest46459843res___t
restart7320033restart
restrict10313633restrict
resubmit1243573resubmit
results739833results
revisit10311373revisit
revolt9316223revol_t
ripplet113412583ripplet
rosolio746983rosolio
slit46250103__s_lit
spait75631603__spait
spilt75532223__spilt
spit65545083__sp_it
splat76129343__splat
splint85223283__splint
splits85416413__splits
sprit76736403__sprit
templet112712003templet
unspilt938853unspilt
uplit76020803__uplit
vespid1246083vesp_id
weskit1338343wes_kit

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271667.26318453.4
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.46923924.4
 
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.