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

309 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
trannies841501(None) 
crannies10313011crannies
grannies9312611grannies
tyrannies1255531tyrannies
brandies11714562brandies
brannier10218932brannier
branniest11199382branniest
crannied1137892crannied
fannies103415642_fannies
grannie8310352grannie_
nannies73015202_nannies
randies84225662_randies
shannies113411262shannies
tannins72813222t_annins
tansies74521242t_ansies
tawnies102812502t_awnies
tennies73017972t_ennies
trainees82712062trainees
trances93919642tra_nces
tranches132915512tranches
transits8313502transits
trendies9312212trendies
truancies1146882truancies
tunnies73614262t_unnies
twankies1535892twankies
tyrannise1253712tyrannise
tyrannises1383972tyrannises
tyrannizes2263472tyrannizes
alanines8314803alanines
araneids947743araneids
atrazines1846683atrazines
bandies104124863_bandies
banties94324763_banties
baronies10315023baronies
beanies93821093bea_nies
bennies93917313_bennies
blennies1056933blennies
brainier102510233brainier
brainiest11209723brainiest
branches153613803branches
brandied1259113brandied
branned104311693brann_ed
branner94212373brann_er
branners104010923branners
branning112911093branning
brassies103613533brassies
braunites1146723braunites
brawnier13216723brawnier
brawniest14197103brawniest
braxies16711463bra_xies
brinies93317913br_inies
brionies10310543brionies
brownies13189613brownies
bryonies1336843bryonies
bunnies94415003_bunnies
candies104125613_candies
canines93724033_canines
cannie83819363_cannie_
cannier94014163_cannier
canniest10313363_canniest
carnies94123963_carnies
chanties132615803chanties
cranches153114543cranches
cranes84330753cra_n_es
crankier14339163crankier
crankiest1538823crankiest
crankles143510153crankles
crannoges1244243crannoges
crannogs1143783crannogs
crappies142911163crappies
crazies183413853cra_zies
cronies9622503cr_onies
cyanines132710543cyanines
dandies94121443_dandies
errancies1147963errancies
fancies124018783_fancies
francizes2346793francizes
frenzies2037713frenzies
funnies104113603_funnies
gradines103615253gradines
grainier9218903grainier
grainiest10188993grainiest
granaries10159883granaries
grandees103211283grandees
granges93516523gra_nges
granites92116363granites
grantees92510973grantees
granules939933granules
gravies11314093gra_vies
greenies9312673greenies
guanines989773guanines
gunnies83413123_gunnies
hankies143617763_hankies
hinnies103615103_hinnies
ironies7517423ir_onies
jennies143511623_jennies
joannes1436243joann_es
johnnies1872993johnnies
mannites10312613_mannites
meanies93620743mea_nies
minnies93617363_minnies
nancies93516843_nancies
nannie63713223_nannie_
ninnies73713613_ninnies
oranges84215333ora_nges
orangier947713orangier
orangiest1038463orangiest
organdies1187213organdies
pandies104224503_pandies
pannes85522853_pann_es
pannier93613353_pannier
panniers10488853_panniers
pansies94521983_pansies
panties94230933_panties
pennies94218813_pennies
pinnies93318443_pinnies
prairies10411453prairies
pralines102217723pralines
prances113618773pra_nces
rabbies113416053_rabbies
rabies85226023_ra_bies
raggies93214733_raggies
rainier71614263_rainier
rainiest81214923_rainiest
rallies73823343_rallies
ramies84630463_ra_mies
rances84625443_ra_nces
ranches123620113_ranches
randier83618473_randier
randiest93418773_randiest
ranees64623963_ra_nees
ranges73826923_ra_nges
rangier83714353_rangier
rangiest93115983_rangiest
ranids75118703_ra_nids
ranis55235833_ra_ni_s
rankles113114543_rankles
ranpikes1435643_ranpikes
rapines95120863_rapines
ratanies8312923_ratanies
ratines75328583_ratines
ravines104220233_ravines
rennins74013413_rennins
runnier74010113_runnier
runniest82911203_runniest
sanies63031953_sa_nies
scanties103215423scanties
shandies122714113shandies
shanties113116593shanties
shinnies113010913shinnies
sonnies7315223_sonnies
spinnies103210543spinnies
stanines85115673stanines
stannites947023stannites
stramonies1246653stramonies
stranges94516763stra_nges
strangles103011553strangles
tabbies112913503t_abbies
taenias7311283t_aenias
taffies133012693t_affies
talkies113415733t_alkies
tallies73624603t_allies
tammies113814683t_ammies
tangier83013903t_angier
tangiest92915223t_angiest
tangles83920043t_angles
tannages9228963t_annages
tannates81911953t_annates
tanned75219953t_ann_ed
tanner63722283t_ann_er
tanneries9310423t_anneries
tanners74018393t_anners
tannest72617853t_ann_est
tannic82811473t_anni_c
tannin62613923t_anni_n
tanning83618253t_anning
tannings9268633t_annings
tannish101610573t_annish
tannoys1055553t_annoys
tardies84225863t_ardies
tarries73324263t_arries
tassies74918933t_assies
tatties74120343t_atties
tawnier10318463t_awnier
tawniest11279343t_awniest
tawpies12309873t_awpies
taxies135817333t_a_xies
tenancies1149173tenancies
tennis64015303t_enni_s
tennises82810133t_ennises
ternaries9311643ternaries
tetanies8513553tetanies
thanages12107623thanages
thanes94918983tha_n_es
tinnier72910143t_innier
tinniest82911463t_inniest
toadies82914863toa_dies
tonnes65320853t_onn_es
toonies73719883t_oonies
townies103113623t_ownies
traceries11312863traceries
traces85329933tra__ces
trachles13311753trachles
tracings112910413tracings
trades75724503tra__des
traduces1136563traduces
traffics1644183traffics
tragedies1146523tragedies
tragics10338083tra_gics
traiks104013713tra__iks
trails64622513tra__ils
trained84117203train_ed
trainee72817793train_ee
trainer73316793train_er
trainers83114643trainers
training93015863training
trainings10246723trainings
trainmen1046153trainmen
trains64725343tra__ins
traipses1036873traipses
traits65121983tra__its
tramlines1139843tramlines
trampier12318243trampier
trampiest13227903trampiest
tramples122610203tramples
trance84718763tra_nce_
tranced104414173tra_nced
tranche123312223tranche_
trancing112812023trancing
trangams1147203trangams
tranks104017763tra_n_ks
tranny94210863trann__y
tranqs155210313tra_n_qs
trans54933043tra_n__s
transfer1138433transfer
transfers1238053transfers
transfixes2046473transfixes
tranships14410333tranships
transient9713213transient
transients1078903transients
transit7317163transi_t
transited10410603transited
transmits1149273transmits
transoms1048933transoms
transpires1249313transpires
transudes1047593transudes
trapes85024463tra__pes
trapeses1039153trapeses
trapezes1936543trapezes
traplines11310373traplines
trapnest10310923trapn_est
trashes104119263tra_shes
trashier113210103trashier
trashiest123110643trashiest
trasses74819323tra_sses
travails1146083travails
traves94222743tra__ves
travois1037883travoi_s
travoise1145603travoise
travoises1245863travoises
treaties8316983treaties
trenails869843trenails
trenches133512603trenches
trendier937913trendier
trendiest1038423trendiest
triangles1035743triangles
triazines1847543triazines
trienes74118413trien_es
trientes82812123trientes
tries55742813tr___ies
trilbies1037693trilbies
trindles93211683trindles
trines64132563tr_in_es
trinities9313343trinities
triunes74311383triun_es
trollies8310233trollies
trones65629283tr_on_es
trophies13413673trophies
tropines102214923tropines
trounces1037063trounces
truantries1044023truantries
trundles9278483trundles
trunnel745403trunn_el
trunnels844513trunnels
trunnion843273trunnion
trunnions943003trunnions
trusties82712853trusties
twangier1254243twangier
twangiest1355223twangiest
twangles1245743twangles
tweenies11146393tweenies
twenties1137503twenties
twinkies1535983twinkies
twoonies1155693twoonies
tyramines1447213tyramines
tyrannic1344143tyranni_c
tyrannised1483063tyrannised
tyrannize2163373tyrannize
tyrannized23103043tyrannized
tyrannizer2262583tyrannizer
tyrannizers2352023tyrannizers
tyrannous1243253tyrannous
uranias72113813ura_nias
uranides92211283uranides
uraninites1045623uraninites
uranites82514643uranites
whinnies14237273whinnies
wrangles1237463wrangles
zanies153219673_za_nies

Search took 8 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.436409841.7
2DLD Change Limit1461623096.98320931.1
3Display Results3093090.1262452.4
 (SQL Overall)1786913097.54523683.4
 
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.