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

288 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
turnery1035742(None) 
turner63914611turner_
turners73912891turners
burner83819202burner_
burners94115672burners
fernery1335812fernery
gunnery11376362gunnery
gurney10429412gurne_y
nunnery10355292nunnery
nursery10396022nursery
ornery938462_ornery
surgery11319202surgery
tannery10388652tannery
ternary1038342ternary
tourney1036272tourne_y
tuner56022682tu_ner_
tuners64417342tu_ners
turbary1236382turbary
turkey1337762turke_y
turned73914472turne_d
turnkey1433012turnkey
tushery1335632tushery
artery9911453_artery
barney115314453barne_y
beanery1237563beanery
briery114510773_briery
buggery14367933buggery
burger94020793burger_
burgers103918573burgers
burier84324653burier_
buriers94017193buriers
burker125221173burker_
burkers133716623burkers
burler84723833burler_
burlers94120273burlers
burley114715753burle_y
burned95818963burne_d
burnet84326173burne_t
burnets93813263burnets
burrer83718473burrer_
burrers93814493burrers
burry105221563bur__ry
bursary12397583bursary
bursera936763bursera
butlery12369423butlery
buttery124311193buttery
cannery123610003cannery
carney115315703carne_y
churner12298343churner_
churners13316883churners
corner84625623corner_
corners94723313corners
cunner83915003cunner_
cunners93913463cunners
curber104517053curber_
curbers115514373curbers
curer75030753cur_er_
curers84923183cur_ers
curler85221323curler_
curlers94218063curlers
curriery13326163curriery
curry105920343cur__ry
curser84721473curser_
cursers94317153cursers
cursory12406393cursory
curter85320073curter_
curtesy1265833curtesy
curvey144111843curve_y
cutlery12448393cutlery
darner74017303darner_
darners83815773darners
deanery1137613deanery
dunner73913823dunner_
dupery12378743du_pery
durned84113173durne_d
earner63617223earner_
earners74016453earners
finery124512883_finery
forgery14419303forgery
fullery13337973fullery
funner93414103funner_
furler93616403furler_
furlers104214223furlers
furmety1534813furmety
furriery14395673furriery
furry116719283fur__ry
garner73917003garner_
garners83815983garners
gunner73813983gunner_
gunners83111723gunners
gurnard944773gurnard
gurnet74920873gurne_t
gurnets84010793gurnets
gurneys11406463gurneys
gurry94515413gur__ry
guttery11427753guttery
hennery1335293hennery
hungry1334973hu_ngry
hurler94717223hurler_
hurlers103714323hurlers
hurley125012523hurle_y
hurry114917183hur__ry
hurter93915853hurter_
hurters103413633hurters
joinery17366593joinery
journey1734873journe_y
lurer54625313lur_er_
lurers64217493lur_ers
lurker103613293lurker_
lurkers113910083lurkers
mercery14397623mercery
mourner938083mourner_
mourners1036913mourners
mummery13336663mummery
murder93613783murder_
murders103311363murders
murker123715243murker_
murrey114312253murre_y
murry105120233mur__ry
nurser64314503nurser_
nursers74311833nursers
onery8414113__onery
orrery936783_orrery
pinery115214283_pinery
prudery1335243prudery
pruner83413453pruner_
pruners93710723pruners
puckery18306263puckery
puffery18235113puffery
punner84918153punner_
punners94114233punners
purely114013613pur_ely
purer75127903pur_er_
purger94717233purger_
purgers104714003purgers
purser85020473purser_
pursers93916093pursers
purvey14559573purve_y
quavery22225483quavery
query174212083qu__ery
quinary1936933quinary
quivery22265453quivery
returner8397983returner_
returners9376553returners
rubbery14337593rubbery
rudery10419033ru_dery
ruiner64013643ruiner_
ruiners74213023ruiners
runner63814463runner_
runners74212453runners
scenery1236553scenery
sorcery1237023sorcery
sorner64720383sorner_
sorners73416863sorners
spurner9269653spurner_
spurners10288493spurners
sterner7411913sterner_
stunner7349193stunner_
stunners8277923stunners
summery14329413summery
sundry1057943su_ndry
surely93816453sur_ely
surer54833093sur_er_
surety93515003sur_ety
surfer93515883surfer_
surfers103614133surfers
surger74320093surger_
surgers83517483surgers
surrey94414573surre_y
survey124111663surve_y
tanner63722283tanner_
tanners74018393tanners
tarry85422513tar__ry
tarter64023563tarter_
tawney12338233tawne_y
teener64717503teener_
teeners74415453teeners
tenner64117103tenner_
tenners74014923tenners
termer85717253termer_
termers95414503termers
terne56426153terne__
ternes65422903terne_s
terry84721873ter__ry
tersely1038103tersely
terser67317823terser_
thuggery1642563thuggery
thundery1533823thundery
timbery14256873timbery
tindery11389353tindery
tinner64119953tinner_
tinners73717303tinners
toggery12505923toggery
toner55336243t_oner_
toners64128003t_oners
toney86027413t_one_y
tonner64819203tonner_
tonners73816403tonners
torero6313203tor_ero
torrefy1353353torrefy
tottery10388483tottery
tourer64115073tour_er_
tourers73512733tour_ers
tourneys1134013tourneys
towery124012093t_owery
tracery12399793tracery
trendy10469603t_rendy
trey77228793t_r_e_y
trier54328533t_rier_
triers64321523t_riers
trinary1039163trinary
truantry1142533truantry
truer54916643t_ruer_
trumpery1533613trumpery
tuatera756363tuatera
tubber104313203tubber_
tubbers113411243tubbers
tuber75420683tu_ber_
tubers85017023tu_bers
tucker124316953tucker_
tuckers134014353tuckers
tufter9319933tufter_
tufters10298343tufters
tugger84013103tugger_
tuggers93711443tuggers
tumefy1434223tu_mefy
tundra736423tu_ndra
tune45635863tu_ne__
tuned64622313tu_ne_d
tunes55332193tu_ne_s
tuneup835203tu_neup
tunned74014493tunne_d
tunnel64310633tunne_l
tunnels7328723tunnels
tunny86515033tu_n_ny
turbeth1274713turbeth
tureen63312723tur_een
tureens7289873tureens
turfed103110963turfe_d
turfier10249793turfier_
turfy114315403tur__fy
turgency1444833turgency
turgent8712393turgent
turgor736863turgor_
turgors836823turgors
turkeys1434523turkeys
turmeric1244643turmeric
turn46330383turn___
turneries948493turneries
turning83713183turning
turnip836593turn_ip
turnips935013turnips
turnkeys1542123turnkeys
turnoff1344013turnoff
turnon638193turn_on
turnons737863turnons
turnout7410283turnout
turnover1143593turnover_
turnovers1243283turnovers
turns55623233turn__s
turnup835093turn_up
turnups933893turnups
turpeth1284813turpeth
turret63121853turre_t
turrets73010673turrets
turtler72610323turtler_
turtlers8258203turtlers
turves94212693turve_s
tusker104212193tusker_
tuskers113710033tuskers
tusser64615833tusser_
tussers74313563tussers
tuyer85414293tu_yer_
tuyere9408613tu_yere
tuyers94612563tu_yers
twiner94012593twiner_
twiners10459633twiners
unary8315993_u_nary
urger64116473_urger_
urgers73313623_urgers
urinary1037243_urinary
venery123710663_venery
vinery124912593_vinery
warner93717223warner_
warners103315563warners
winery125014273_winery
yarner93313063yarner_
yarners104312203yarners

Search took 10 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272888.81315207.9
3Display Results2882880.0933096.8
 (SQL Overall)1786912889.06219718.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.