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

150 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
torrents83814(None) 
torments10310451torments
torrent7313411torrent_
corrects1259572corrects
currents1038372currents
horrent10313552horrent_
mordents1138812mordents
orients7311582_orients
portents103512822portents
sorbents10279132sorbents
terrenes82212602terrenes
terrets72913582terre_ts
torment9316172torment_
turrets73010672turre_ts
argents84014853_argents
arpents93613083_arpents
arrests73312683_arrests
barrens94414323barren_s
barrets94917103barre_ts
boreens9310403boreen_s
brents84717273__brents
coagents1138453coagents
coerects1258543coerects
comments142913883comments
concents122516603concents
consents102715893consents
contents104018213contents
convents132614603convents
coparents1347973coparents
cornets94820573corne_ts
coronets103814363coronets
correct11513983correct_
corrupts1244983corrupts
corsets94819803corse_ts
corvets124715023corve_ts
courants10310803courants
currants1037933currants
current9313693current_
deterrents11126473deterrents
docents102810803do_cents
errants7410643_errants
ferments13311473ferments
ferrets103111393ferre_ts
foments122912053fo_ments
forests104114953fo_rests
forfeits1445803forfeits
forfends1544833forfends
forgets113813793forge_ts
forints10411833fo_rints
formants13269953formants
fornent10312933fornent_
forwent13310533forwent_
garments1139963garments
garrets84413623garre_ts
gerents82612923_gerents
gorgets94711783gorge_ts
gorhens1137183gorhen_s
hornets104113553horne_ts
loments93413473lo_ments
margents11410133margents
moments113113123mo_ments
mordants1137143mordants
mordent10313993mordent_
moreens939963moreen_s
morgens10310463morgen_s
orgeats838353_orgeats
orient6322533_orient_
parents93418123_parents
percents122713373percents
perpents122312043perpents
porrect1159743porrect_
portends11358963portends
portent93619643portent_
rents55935183___rents
reorients997363reorients
rerents73319423_rerents
rodents8611543ro_dents
sarments10311963sarments
serpents102410373serpents
solvents1136763solvents
sorbent92915243sorbent_
sorbets93012513sorbe_ts
sorrels7310723sorre_ls
subrents10310293subrents
talents7312013t_alents
tangents938713tangents
targets84314223targe_ts
tarres64723043tarre__s
tents56434213t___ents
tercets93512443terce_ts
terpenes102111573terpenes
terranes82514433terranes
terreens8246533terreens
terrene72411033terren_e
terret63425623terre_t_
terrines82117553terrines
territs72714503terr_its
threats104311673t_hreats
titrants838483titrants
toilets74112913toile_ts
tokens104711563to_ken_s
toluenes836763toluenes
tomenta9319833to_menta
tonlets73212503tonle_ts
toquets16367863toque_ts
toreros7311343to_reros
tores55352673to_re__s
tories65435883torie__s
tormented1245963tormented
tormenter1146703tormenter
tormenters1245823tormenters
tormentil1144223tormentil
tormentils1243773tormentils
tormentor1144363tormentor
tormentors1244173tormentors
torpedos1143933torpedos
torrefies12114753torrefies
torrefy1353353torre_fy
torrential1054483torrential
torrs53923563torr___s
torses64727953torse__s
torten65314353torten__
tortes64826053torte__s
tortonis848743tortonis
torts56138123to_r__ts
tourers73512743toure_rs
tourings9277373tourings
tourists838313tourists
tourneys1134013tourneys
towmonts1364283towmonts
treats64821693t__reats
treens65317873t_reen_s
trends75513543t__rends
trets55928023t__re_ts
tridents938583tridents
trienes74118413t_rienes
triens65417543t_rien_s
trientes82812123t_rientes
truants738163t_ruants
tureens7289873tureen_s
turgent8712393turgent_
turret63121853turre_t_
tyrants1037453t_yrants
varments1339063varments
warrants1168503warrants
warrens103810893warren_s
worriments1544153worriments
worrits10258683worr_its
worsens104610263worsen_s
worsets105512843worse_ts

Search took 7 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.423422437.4
2DLD Change Limit1461621506.43622710.1
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.92225814.9
 
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.