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 “trains” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
trains6472534(None) 
brains85125471brains
drains73719401drains
grains74223091grains
rains55140231_rains
strains74218151strains
tains54936321t_ains
traiks104013711traiks
trails64622511trails
train56529111train_
traits65121981traits
trans54933041tra_ns
twains95811181twains
ains46158882__ains
attains7310982attains
blains84516372blains
braids95015682braids
brails84621292brails
brain76229382brain_
brainy114815642brainy
brans75437432bra_ns
brawns115614082brawns
brins75533972br_ins
bruins86014952bruins
cains75334302_cains
chains114819702chains
detrains9411752detrains
drails74716952drails
drain65222892drain_
elains64919852elains
entrains8312962entrains
frails93716472frails
gains65729512_gains
gradins93416232gradins
grails77518782grails
grain65126252grain_
grainy103914212grainy
grans64832542gra_ns
gratins84119182gratins
grins65427222gr_ins
groins73917202groins
kains96125642_kains
kraits104912202kraits
mains75635092_mains
orcins83313432orcins
ordains879652ordains
orpins83614162orpins
pains75138282_pains
plains85019592plains
prawns11509022prawns
raias54631122_raias
raids65827512_raids
rails55937402_rails
rain46251732_rain_
rainy85921082_rainy
rais45252622_rai_s
ranis55235832_ranis
ravins94622562_ravins
rawins95617622_rawins
reins56234562_reins
retrains8314522retrains
rins46153192_r_ins
ruins55822032_ruins
sains55639972_sains
sarins63932622sarins
sprains93013592sprains
stains64923652stains
strain64919572strain_
straits74916322straits
swains94513952swains
tails55634192t_ails
tain45548072t_ain_
taint55542282t_aint
taints64520532t_aints
takins105117402takins
tans46154812t_a_ns
taring73932282taring
tarns56433952t_arns
terais64023502terai_s
terrains8410292terrains
theins95015422theins
thins85826322t_hins
tins45251302t__ins
toxins133314282toxins
traces85329932traces
tracing103720152tracing
tracings112910402tracings
tracks124818842tracks
tracts85019072tracts
trades75724492trades
trading93517972trading
tragics10338082tragics
tragus749222tragus
traik95418202trai_k
trail55126772trai_l
trained84117202trained
trainee72817792trainee
trainees82712062trainees
trainer73316792trainer
trainers83114632trainers
traipse935872traipse
trait56940842trai_t
tramps105114452tramps
trams75327672tra_ms
trank96222422tra_nk
tranks104017762tranks
tranny94210862tranny
tranq145416892tra_nq
tranqs155210312tranqs
trapans92812462trapans
trapes85024462trapes
traps75727482tra_ps
trass56226472tra_ss
traves94222742traves
trawls94412392trawls
trays85623432tra_ys
treens65317872treens
triacs83913222triacs
triads74513522triads
trials64319882trials
triazins1738342triazins
triens65417542triens
tries55742812tr_ies
trigs65423062tr_igs
trims75021472tr_ims
trine54734602tr_ine
trines64132562tr_ines
trios55528092tr_ios
trips74923362tr_ips
trois57226092troi_s
tropins93116302tropins
truing73913932truing
trying104214072trying
twain86313622twain_
twins85118982t_wins
vitrains1138282vitrains
wains86930862_wains

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511372.76629844.9
3Display Results1371370.0462978.3
 (SQL Overall)1786911372.92261153.7
 
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.