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

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

91 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
transistors115574(None) 
transistor1046201transistor_
transactors1364702transactors
transistorise13143852transistorise
transitory1355692transi_tory
translators1156442translators
assistors945253__assistors
resistors947993_r_esistors
traitors8310793tra__i_tors
transactor1265173transactor_
transferors1484493transferors
transistorised15142843transistorised
transistorises14253553transistorises
transistorize22143403transistorize
transistorizes23293343transistorizes
transitions1148923transitions
transits8313503transi_t__s
translator1047223translator_
translatory1454803translatory
transmitters1484393transmitters
ancestors1147234__ancestors
antistory1248274__antistory
assisters936354__assisters
assistor844824__assistor_
banisters11189474_ban_isters
bannisters1244324_bannisters
brachiators1853524brachiators
canisters112310204_can_isters
cannisters1245024_cannisters
consistory1545574_consistory
franchisors1952374franchis_ors
ganisters10248314_gan_isters
gannisters1153844_gannisters
grantors93810364gran___tors
granulators1244614granulators
insisters997654__insisters
janitors1536854_jan_i_tors
pranksters1653294pran_ksters
radiators1049334_ra_diators
resisters9310454_r_esisters
resistor847674_r_esistor_
tanistry1144544t_an_ist_ry
tanists7313664t_an_ist__s
tarantists1055334tarantist__s
thermistors1653094thermistors
thyristors1652514t_hyristors
tractors10312574tra___ctors
traditor945944tra_di_tor_
traditores1145244tra_di_tores
traitor7310124tra__i_tor_
transactions1445884transactions
transacts1157364transact__s
transducers1453584transducers
transections1446764transections
transects1157824transect__s
transepts1146384transept__s
transferor1394524transferor_
transfers1238054tran__sfers
transfixions2253934transfixions
transform1446204tran__sform
transforms1545834tran__sforms
transfusions1553934transfusions
transgressors1461484transgressors
transiences13128284transiences
transients1078914transi_ents
transistorising16111924transistorising
transistorized24142884transistorized
transit7317164transi_t___
transited10410604transi_t_ed
transiting11410774transi_ting
transition1049704transi_tion
transitive1348494transi_tive
transitorily1554054transi_torily
translates10411704translat_es
translations1258374translations
transmigrators1762224transmigrators
transmissions1554124transmissions
transmits1149274transmit__s
transmittals1453454transmittals
transmitter1395364transmitter_
transmutes1247304transmut_es
transoms1048934tran__s_oms
transpicuous1662194transpicuous
transport1149754tran__sport
transporters1454814transporters
transports1247574tran__sports
transposons1354584transposons
transships1546784trans_ships
trisectors1244464tr_isectors
trustors8268914tr___ustors
varistors1246534_va_ristors

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 Filter1786911488190.420425454.8
2DLD Change Limit148819918.62617252.4
3Display Results91910.0461978.3
 (SQL Overall)178691919.09219653.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.