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

271 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
retyping1425561(None) 
pretyping1764941pretyping
retaping113012551retaping
retying113213831rety_ing
pretaping1439132pretaping
reaping103621212re_aping
redyeing1336172redyeing
relying112914612rely_ing
repping123314982re_pping
restyling1337922restyling
retaking133114282retaking
retaxing162311332retaxing
retching143412172retching
retieing92913712retieing
retiling93319482retiling
retiming113014192retiming
retiring92717412retiring
retrying122410452retrying
retting83425882ret_ting
retuning9311582retuning
typing124110582__typing
beeping124013913be_eping
belying133612443bely_ing
betaking153010153betaking
betiding1239913betiding
betting103921403bet_ting
creeping133310103cre_eping
creping122913653cre__ping
defying15328823defy_ing
denying123711293deny_ing
detoxing1736313detoxing
eloping103512833_eloping
espying1336193_espying
etching134511843_etching
eyeing10429363_e_yeing
eying96117923_e_y_ing
fetching17298413fetching
feting104417793fet__ing
fetting113517873fet_ting
fettling1266773fettling
fretting122711523fret_ting
getting93316563get_ting
greying124110893gre_y_ing
heaping133015853he_aping
helping133512223he_lping
hyping15408483__hyping
jeeping174010333je_eping
jetting153815343jet_ting
jettying1933953jettying
keeping144012543ke_eping
kelping14319193ke_lping
kepping16268593ke_pping
keying1438043ke_y_ing
leaping103215993le_aping
letching143810263letching
letting83218533let_ting
levying1435873levy_ing
metaling111613723metaling
metering112915633metering
meting94320593met__ing
metring103215293met_ring
mistyping1744723mistyping
netting84018763net_ting
nettling957213nettling
peeping123615213pe_eping
pepping113511623pe_pping
petering112516813petering
petnaping1444543petnaping
petting103720953pet_ting
pettling1168213pettling
pitying132910243pity_ing
prepping12309763pre_pping
prettying1536043prettying
preying133114553pre_y_ing
ramping123316873r_amping
raping94829853r__aping
rapping123619103r_apping
rasping104316253r_asping
rating74938703rat__ing
ratting83822363rat_ting
rattling92510873rattling
raying105027193r_ay_ing
reaching143317203reaching
reacting113317893reacting
readding11411363readding
reading93327213re_ading
readying13410223readying
reaming103924013re_aming
rearing83128783re_aring
rearming111413613rearming
reaving113820533re_aving
rebating112418343rebating
reboring11312783reboring
rebuking1536693rebuking
rebuying1436743rebuying
recaning111416693recaning
recapping1636453recapping
receding122713763receding
reciting113118073reciting
recking144319923re_cking
recoding122213853recoding
recopying1737113recopying
recouping1438363recouping
recusing112512883recusing
recycling1734903recycling
redating102620173redating
redding103218513re_dding
reddling112911813reddling
reding83825563re__ding
redipping1555593redipping
redoing93516733re_doing
redrying13209023redrying
reducing12310203reducing
redwing122811983re_dwing
reeding94124133re_eding
reedling102414273reedling
reefing114016863re_efing
reeking123318643re_eking
reeling83126863re_eling
reesting93118273reesting
reeving113717663re_eving
refacing142512813refacing
reffing143712173re_ffing
refiling123116533refiling
refining122416863refining
refiring123513923refiring
refixing19329793refixing
reflying15268173reflying
refrying15278903refrying
refuging13218423refuging
refusing122310873refusing
refuting121911903refuting
regaling10315363regaling
regiving13269713regiving
regluing1077033regluing
rehiring122911883rehiring
reifying1539383reifying
reigning1039883reigning
reining84425323re_ining
reinking13311023reinking
reiving113316843re_iving
rekeying1637563rekeying
relacing112516043relacing
relapsing1236843relapsing
relating92725443relating
relaxing162612633relaxing
relaying122515153relaying
relining93218743relining
reliving122713343reliving
reluming11310013reluming
remaking152613303remaking
remapping1635023remapping
remating112322413remating
remising112516453remising
remixing182810333remixing
removing1439083removing
renaming11313693renaming
rending93924263re_nding
reneging102111533reneging
renewing121910713renewing
renting84026853re_nting
reoiling93217213reoiling
repaving142810743repaving
repaying142712393repaying
repin75324703re__pin_
repine85627813re__pine
repining114116593repining
repins84924313re__pins
replying14269403replying
reposing111213803reposing
repumping1634813repumping
reputing112412603reputing
rerising93017783rerising
resawing122311433resawing
resaying122512453resaying
rescuing1139623rescuing
reseeing92412623reseeing
resewing122712263resewing
reshaping1557743reshaping
residing103015473residing
resiling93520173resiling
resining92919553resining
resiting93521123resiting
resizing182714163resizing
resoling92916303resoling
resowing123111523resowing
respring111614063respring
restaging112410853restaging
restamping1565213restamping
restating102319413restating
resting85031183re_sting
restoking1438193restoking
restoring10314613restoring
restring91518783restring
resuming11310083resuming
resupine1037543resupine
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retain64523283ret_ain_
retaining102114733retaining
retains74522253ret_ains
retarding111110653retarding
retasting102513413retasting
reteaming122110443reteaming
retearing102214253retearing
retelling102112493retelling
retesting102614603retesting
rethink1488883ret_hink
retina65023383ret__ina
retine66237333ret__ine
retint65633443ret__int
retinting102215253retinting
retitling1039773retitling
retooling1039093retooling
retorting10613273retorting
retracing12313293retracing
retrain7615423retrain_
retrains8314533retrains
retsina74710603ret_sina
returning1038133returning
retype11399143retyp__e
retyped13367303retyp_ed
retypes12308623retyp_es
reusing82516783re_using
revamping1734633revamping
reveling123117083reveling
revering122918073revering
reviling122917213reviling
revising122714403revising
reviving152910503reviving
revoking1637803revoking
revoting12312033revoting
revving14379343re_vving
rewaking162310983rewaking
rewaxing19248563rewaxing
rewiring122911223rewiring
rezoning18310453rezoning
rhyming1634043r_hyming
riping93821613r__iping
ripping123315743r_ipping
romping123113033r_omping
roping94023023r__oping
rotating92614553rotating
rotting82919683rot_ting
rouping103715793r_ouping
rubying13297933ruby_ing
rutting82718043rut_ting
ryking14348113r__yking
seeping103817913se_eping
serotyping1643123serotyping
setting83621393set_ting
settling978943settling
steeping113412583steeping
stepping13329073stepping
stoping103716623_stoping
stying105414573_sty_ing
styling112910653_styling
taping94222393__taping
teletyping1642473teletyping
temping122710693te_mping
toping94122993__toping
tying96019843__ty_ing
tyning105510413__tyning
tyring104613023__tyring
untying1138943unty_ing
vetoing11309053vet_oing
vetting114216563vet_ting
weeping133613673we_eping
wetting114117383wet_ting
yelping13317873ye_lping

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 Filter1786911461620.326548131.9
2DLD Change Limit1461622718.47017256.4
3Display Results2712710.2031335.0
 (SQL Overall)1786912718.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.