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

207 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
brulots94622(None) 
brulot8912211brulot_
ballots94116032ballots
blots75626172b__lots
bruits85714452bru_its
brumous11107442brumous
brunets9419552brunets
brunts85215452bru_nts
bruts75922952bru__ts
burbots1168672burbots
drylots1143742drylots
adults7299953adul_ts
allots64019173_allots
amulets939923amulets
argots74116033ar_gots
armlets94610063armlets
bailors93212413bailors
bailouts1036613bailouts
ballets93719513ballets
ballons93916963ballons
ballot84624093ballot_
barlows12259973barlows
baulks12429373baul_ks
beclogs1237073beclogs
beknots1335083beknots
bellows124313303bellows
belons84119413b_elons
belows114614183b_elows
belts75931163b_el_ts
besots86415453b_esots
bhoots11459913b_hoots
bhuts105812953bhu__ts
bibelots1295133bibelots
bibulous1244633bibulous
bigots95015133b_igots
billets94516153billets
billons93013363billons
billows123611293billows
blats75132503b__lats
blets75324943b__lets
bloats85215763b__loats
blobs95620033b__lobs
blocs95219653b__locs
blogs85319233b__logs
blot65842323b__lot_
blows105423833b__lows
bluets87215493blu_ets
blunts84512893blu_nts
blurts84412643blu_rts
bolos75531373b_olo_s
bolts76232113b_ol_ts
boots75837973b__oots
bots66453953b___ots
boubous1138693boubous
boules84925973boul_es
boulles93114123boulles
boutons9310783boutons
bouts75131313bou__ts
bowpots1446023bowpots
bracts105617773br_acts
braless92910563braless
brants85723053br_ants
brats75336013br__ats
bravoes12418533bravoes
bravos114711393bravo_s
breasts939703breasts
brents84717273br_ents
brevets12519393brevets
brights133710233brights
brillos9369183brillos
brills84916293bril_ls
brios74725723br_io_s
brits76433083br__its
britts84813443br_itts
bromos104213313bromo_s
broods95416383br_oods
brooks125813883br_ooks
brooms104915873br_ooms
broos75126413br__oos
bros65635663br__o_s
broth106521093br__oth
broths115013923br__oths
brows105425983br__ows
brucins1158003brucins
brughs12509063bru_ghs
bruins86014953bru_ins
bruises93212913bruises
bruit76126723bru_it_
brulyie1242523brulyie
brulyies1343423brulyies
brulzie1842883brulzie
brulzies1933983brulzies
brumes106417073bru_mes
brunet84419293brunet_
brunt75728753bru_nt_
brushes124014663brushes
brut66537963bru__t_
brute75321783bru__te
brutes86118683bru_tes
bruxes154811023bru_xes
buboes104513993b_uboes
bugloss1035893bugloss
bugouts1036193b_ugouts
bulbous1138293b_ulbous
bulbs96016933b_ul_bs
bulges95919323b_ulges
bulks115920613b_ul_ks
bullets93516393bullets
bullous9311663bullous
bulls75629573b_ul_ls
bundts95010843b_undts
bunts75729803b_u_nts
buoys104810633b_u_oys
burbot10815653burbot_
burets84321263b_urets
burgoos1037123burgoos
burgouts1145123burgouts
burlaps1156253burlaps
burlers94120273burlers
burleys12479673burleys
burls74228853burl__s
burnets93813263burnets
burnous938823burnous
burnouts1045263burnouts
burros85114993burro_s
burrows12399093burrows
bursts85116243b_ursts
burtons9310853burtons
busts75227693b_u_sts
buts67247693b_u__ts
butts75824253b_u_tts
bututs8409423b_ututs
buyouts1235203b_uyouts
clots75627643__clots
coplots11511593coplots
cruets85314953cru_ets
cruors838643cru_ors
crusets93811043crusets
crusts84916543cru_sts
culets85518513_culets
cults75022553_cul_ts
diglots9299503diglots
drylot1037403drylot_
emulous937343emulous
ergots74512373er_gots
eructs83610793eru_cts
erugos7347343erugo_s
erupts8348903eru_pts
exults13257633exul_ts
faults94513553faul_ts
fruits94512493fru_its
gaults74112783gaul_ts
giglots9367863giglots
griots74713643gr_iots
grots65025853gr__ots
grumous1086613grumous
grunts75511853gru_nts
guyots1036003_guyots
harlots103413293harlots
helots95217703_helots
krubuts1343013krubuts
lots47652093___lots
marplots1245633marplots
merlots92710123merlots
moults84713703moul_ts
mulcts10298713_mulcts
ocelots977233ocelots
orgulous944213orgulous
orlons6411013or_lons
orlops847303or_lops
pilots84018873_pilots
plots75025673__plots
poults84613483poul_ts
prologs103512133prologs
prutot8311823prutot_
prutoth1243473prutoth
relets64025673_relets
replots93412633replots
repots85621003_repots
riots54922013_r_iots
robots8313153_robots
roots55933673_r_oots
rots46454093_r__ots
rubouts937983_rubouts
rufous948273_rufous
rugous739653_rugous
rulers64317093_rulers
rules55234253_rul_es
rumors81110403_rumors
runlets73310773_runlets
runouts737353_runouts
runts55927633_ru_nts
rusts55026993_ru_sts
ruts44541493_ru__ts
ryots85313783_r_yots
saults65816173saul_ts
sculpts11377063sculpts
slots54830533__slots
sublots92410913sublots
tricots9311563tricots
trots56629943tr__ots
truants738163truants
trulls64110283trul_ls
trusts64714433tru_sts
turbots988023turbots
vaults94511673vaul_ts
zealots1636763zealots

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 Filter1786911340270.393454684.5
2DLD Change Limit1340272076.64020184.8
3Display Results2072070.0633285.7
 (SQL Overall)1786912077.09625181.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.