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

141 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
transits831350(None) 
transit7317161transit_
transmits1149271transmits
tanists7313652t_anists
tansies74521242t_ansies
traits65121982tra__its
trannies8415012trannies
transacts1157362transacts
transects1157822transects
transepts1146382transepts
tranships14410332tranships
transients1078902transients
transited10410602transited
transmit10410912transmit_
transoms1048932transoms
araneids947743araneids
bandits103814793_bandits
bankits133410153_bankits
brandies11714563brandies
brants85723053bran__ts
brasils9410973bra_sils
brassies103613533brassies
crampits1436273crampits
crannies10313013crannies
crasis85020473cra_si_s
grandsirs1144553grandsirs
granita82111303gran_ita
granitas92610223gran_itas
granite82017083gran_ite
granites92116363gran_ites
grannies9312613grannies
grants73722473gran__ts
ironists839293ironists
kraits104912203kra__its
onanists838413onanists
oralists8611803oralists
organists1047383organists
pandits103914213_pandits
pansies94521983_pansies
pianists1049013pianists
rabbits11299863_rabbits
racists92613323_racists
raisins72715343_raisins
randies84225663_randies
ranids75118703_ran_ids
ranis55235833_ran_i_s
ransoms92410163_ransoms
rants55935343_ran__ts
rapists92510753_rapists
resits64725563_r_esits
retransmits13142873retransmits
straits74916323stra__its
tahsils1035053t_ahsils
tallits73215993t_allits
tanist6324593t_anist_
tannins72813223t_annins
tarantist948913tarantist
tarantists1055333tarantists
tarsias74013373t_arsias
tassets75012773t_assets
tassies74918933t_assies
tennists8297793tennists
tensity1039103t_ensity
toasts65914993toa_s_ts
tonsils7310183t_onsils
tracksuits1652063tracksuits
tracts85019073tra__cts
traffics1644183traffics
tragics10338083tra_gics
traiks104013713tra__iks
trails64622513tra__ils
trains64725343tra__ins
trait56940843tra__it_
trajects1744533trajects
trances93919643tran_ces
tranches132915513tranches
trancing112812023trancing
trangams1147203trangams
tranks104017763tran__ks
tranqs155210313tran__qs
trans54933043tran___s
transact1049823transact
transcripts1554433transcripts
transect10410053transect
transept1048633transept
transfects1545723transfects
transfer1138433transfer
transfers1238053transfers
transfix1844983transfix
transfixes2046473transfixes
transfixt1955833transfixt
transfuse1246013transfuse
tranship13410183tranship
transient9713213transient
transistor1046203transistor
transistors1155743transistors
transiting11410773transiting
transition1049703transition
transitions1148923transitions
transitive1348493transitive
transitory1355693transitory
translate9412273translate
translates10411703translates
transmute1157183transmute
transmutes1247303transmutes
transom948823trans_om
transpire1148863transpire
transpires1249313transpires
transports1247573transports
transpose1146883transpose
transships1546783transships
transude947083transude
transudes1047593transudes
trapnests1144433trapnests
trashes104119263tra_shes
trass56226473tra_s__s
trasses74819323tra_sses
travails1146083travails
travois1037883travoi_s
trenails869843trenails
trendies9312213trendies
trinity10310843trin_ity
trinkets1237143trinkets
truancies1146883truancies
truants738163truan__ts
trusts64714433tr_us_ts
trypsins1344893trypsins
trysts9448793tr_ys_ts
tsarists857303tsarists
turnspits1142573turnspits
twankies1535893twankies
twinsets1133663twinsets
tyrannies1255533tyrannies
tyrants1037453tyran__ts
tzarists1755693tzarists
uranias72113813uran_ias
uranisms1099973uranisms
uranite72515693uran_ite
uranites82514643uran_ites
urbanists11105483urbanists
whatsits1443543whatsits

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.1561145455.1
2DLD Change Limit1461621418.11018022.4
3Display Results1411410.0602350.0
 (SQL Overall)1786911418.32621461.8
 
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.