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

259 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
trainees8271206(None) 
trainee72817791trainee_
trainers83114641trainers
drainers92811252drainers
grainers93012072grainers
gratinees10307322gratinees
ranees64623962_ra_nees
retrainees1046392retrainees
strainers9510382strainers
trailers82912922trailers
trained84117202train_ed
trainer73316792train_er
trainmen1046152trainmen
trains64725342train__s
traipses1036872traipses
trances93919642tra_nces
trannies8415012trannies
trienes74118412tr_ienes
trines64132562tr_in_es
arsines73518813arsin_es
artiness81615403artiness
atrazines1846683atrazin_es
attainers9115593attainers
bailees93914383_bailees
braiders114110573braiders
brailles1039493brailles
brained103816103brain_ed
brainier102510233brainier
brainiest11209723brainiest
brainless1136403brainless
brains85125473brain__s
braises93818873brai_ses
braizes183112453brai_zes
branners104010923branners
bribees11409283br_ibees
briners94315633br_iners
brines85028853br_in_es
brinies93317913br_inies
chaines124518733chain_es
cranes84330753cra_n_es
crannies10313013crannies
craziness2037383craziness
cringes103215503cr_inges
detainees10267153detainees
drabness1135803drabness
draftees12225253draftees
dragees9359483dra_gees
dragnets10136563dragnets
drainages1145503drainages
drained93713253drain_ed
drainer83012843drain_er
drains73719403drain__s
drawees11378363dra_wees
entrainers1086963entrainers
ermines9416673ermin_es
examinees18123783examinees
frailness1236543frailness
fraises104215693frai_ses
fringes113514103fr_inges
frisees104411693fr_isees
gainers84214593_gainers
gradines103615253gradin_es
grained93814273grain_ed
grainer83714063grain_er
grainier9218903grainier
grainiest10188993grainiest
grainless1035893grainless
grains74223093grain__s
grandees103211283grandees
granges93516523gra_nges
granites92116363granites
grannies9312613grannies
grantees92510973grantees
grapiness1238253grapiness
grapnels1134393grapnels
gratinee93710783gratinee_
gratineed11334473gratineed
grayness1235933grayness
mariners103113863mariners
marines93928013marin_es
matinees102110423matinees
moraines10314363morain_es
nominees1037363nominees
oranges84215333ora_nges
ordainers1055113ordainers
ordines83014903ordin_es
orpines94414793orpin_es
pawnees12298173_pawnees
prairies10411453prairies
praisers103410833praisers
praises94121103prai_ses
pralines102217723pralin_es
prances113618773pra_nces
prawners1346003prawners
princes113015143pr_inces
raciness102413453_raciness
ragees74618663_ra_gees
raggees93710913_raggees
raiders84615143_raiders
railers74420663_railers
rained75024603_rain_ed
rainier71614263_rainier
rainiest81214923_rainiest
rainless8129703_rainless
rains55140233_rain__s
raisers73617393_raisers
raises64826543_rai_ses
rakees104516973_ra_kees
ramees84620893_ra_mees
rances84625443_ra_nces
ranee55438103_ra_nee_
ranges73826923_ra_nges
rapines95120863_rapin_es
rappees113611453_rappees
ratines75328583_ratin_es
ravines104220233_ravin_es
rawness1038153_rawness
razees154314763_ra_zees
retrainee9511163retrainee_
rinses64720383_r_inses
ruiners74213023_ruiners
stainers83212173stainers
strained9412253strain_ed
strainer8512223strain_er
strains74218153strain__s
straitens946233straitens
straitness1046293straitness
stranges94516763stra_nges
tailers73720183t_ailers
tailles72516473t_ailles
tains54936323t_ain__s
tainted83512423t_ainted
taints64520533t_ain_ts
tanners74018393t_anners
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tartness82210133tartness
tawneys13324773t_awneys
tawnies102812503t_awnies
teariness9310633teariness
terrines82117553terrin_es
thanes94918983tha_n_es
theines104013233thein_es
tidiness938793tidiness
tineas64616483t__ineas
tines54848423t__in_es
tinges74722333t__inges
tininess8310633tininess
tirrivees1242003tirrivees
townees10269783t_ownees
toxines142912263toxin_es
tracers94917843tra_cers
traces85329933tra__ces
tracheas13410273tracheas
trachles13311753trachles
tracings112910413tracin_gs
trackers143512853trackers
traders84316953tra_ders
trades75724503tra__des
traduces1136563traduces
traiked123310453trai_ked
traiks104013713trai__ks
trailed83415673trai_led
trailer73015393trai_ler
trailered1045393trailered
trailless935963trailless
trails64622513trai__ls
train56529113train___
traineeship1652373traineeship
trainful1145183trainful
trainfuls1243953trainfuls
training93015863training
trainings10246723trainings
trainman1046233trainman
trainway1444223trainway
trainways1543023trainways
traipse935873traipse_
traipsed1134753traipsed
traitors8310793traitors
traitress944403traitress
traits65121983trai__ts
tramels93812493tra_mels
tramless1037503tramless
tramlines1139843tramlin_es
trammels12295413trammels
trampers123210393trampers
tramples122610203tramples
trance84718763tra_nce_
tranced104414173tra_nced
tranches132915513tranches
tranks104017763tra_n_ks
tranqs155210313tra_n_qs
trans54933043tra_n__s
trapes85024463tra__pes
trapeses1039153trapeses
trapezes1936543trapezes
traplines11310373traplin_es
trapnest10310923trapnest
trapnests1144433trapnests
trappers123711043trappers
trashers113013643trashers
trashes104119263tra_shes
trashiness1346443trashiness
trasses74819323tra_sses
travels104711293tra_vels
traves94222743tra__ves
trawlers113310203trawlers
trawleys14284383trawleys
trawlnets1242843trawlnets
trees55835763tr___ees
triages82613793tr_iages
triangles1035743triangles
triazines1847543triazin_es
tribes85119023tr_i_bes
triceps11267343tr_iceps
trices84826333tr_i_ces
triene64316383tr_iene_
triens65417543tr_i_ens
trientes82812123trientes
triers64321523tr_i_ers
tries55742813tr_i__es
trifles103814823tr_ifles
trigness968403trigness
trijets14308263tr_ijets
trikes105419493tr_i_kes
trimers94615143tr_imers
trimness1067563trimness
trindles93211683tr_indles
trine54734603tr_in_e_
trined74920713tr_in_ed
trinket11314813tr_inket
trinkets1237143tr_inkets
triodes84012503tr_iodes
trioses75015653tr_ioses
tripes85324873tr_i_pes
triples94616873tr_iples
triremes1035523tr_iremes
trisemes1036643tr_isemes
triunes74311383tr_iunes
trivets103911583tr_ivets
trochees132510183trochees
trones65629283tr_on_es
tropines102214923tropin_es
trounces1037063trounces
trueness838693trueness
trunnels844513trunnels
trustees8339323trustees
turbines1039903turbin_es
twains95811183twain__s
twiners10459633t_winers
twines94717273t_win_es
twinges11409453t_winges
tyramines1447213tyramin_es
tyrannies1255533tyrannies
uranides92211283uranides
uranites82514643uranites
urines64724123ur_in_es
wariness11313213wariness

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.423422437.4
2DLD Change Limit1461622597.57619292.8
3Display Results2592590.1102354.5
 (SQL Overall)1786912598.10922036.1
 
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.