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

97 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
resistor84767(None) 
resister8311651resister
resistors947991resistors
assistor844822assistor
register939552register
remittor10316552remittor
resist64524532resist__
resisted9312692resisted
resisters9310452resisters
resists74414922resist_s
revisor10388732revis_or
assister836753assister
assistors945253assistors
creditor1145903credi_tor
demister11310223demister
depictor1355513depictor
desist74818813desist__
desisted1039783desisted
desists83611723desist_s
deviator1248313deviator
devisor11357043devis_or
editor738663_edi_tor
evictor12346363_evictor
genitor837273geni_tor
heister103613623he_ister
helistop1344323helistop
heritor10310563heri_tor
hesitator1286023hesitator
insister888783insister
keister113011573ke_ister
leister73212753le_ister
lessor64010603les_s_or
mediator1139043mediator
meister93114163me_ister
nestor63713423ne__stor
persister1146833persister
predictor1447093predictor
prehistory1845323prehistory
pressor93512883pres_s_or
previsor13116303previs_or
radiator949203radiator
reactor93011663re_actor
realtor73611353re_altor
receiptor1343493receiptor
receptor1256693receptor
recision10310273recision
reciter94117263reci_ter
rector84019753re__ctor
redactor1147033redactor
reductor1156433reductor
refilter1137153refilter
registers1038893registers
registrar1042783registrar
registry1244633registry
reinter73116843re_inter
reissuer854523reissuer
rejector17237723rejector
relator74016373re_lator
relist64628413relist__
relisted9312623relisted
relists73817053relist_s
remaster10311473remaster
remitter102810323remitter
remittors11256283remittors
requestor1853023requestor
rescissory1551803rescissory
resetter81511833resetter
resider84615803resi_der
resift94017723resift__
resifted12310153resifted
resifts10378703resift_s
resigner937793resigner
resilver11337503resilver
resistant948613resistant
resisting103215313resisting
resistive1247583resistive
resit54241043resi_t__
resite64128453resi_t_e
resited85122423resi_ted
resites74027793resi_tes
resits64725563resi_t_s
resonator946363resonator
resorter8312183resorter
respirator1265733respirator
rester63832433re__ster
restore75822983re__store
reviser104114663revis_er
revision1138713revision
revisors11379063revis_ors
revisory14306013revis_ory
roister73516203r_oister
seisor63712343se_is_or
sister64421583__sister
testator847373testator
transistor1046203transistor
varistor1146393varistor
visitor1046203visi_tor

Search took 9 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.420425454.8
2DLD Change Limit146162978.31317582.3
3Display Results97970.0303233.3
 (SQL Overall)178691978.76320391.5
 
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.