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

213 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
oblasts94730(None) 
blasts85116771_blasts
oblast8613661oblast_
oblasti945951oblasti
ablauts936082ablauts
basts75936932_b_asts
beasts84519722_beasts
blast76532572_blast_
blasty115611052_blasty
blats75132502_bla_ts
boasts85017922_boasts
bolases93315002bolases
clasts84817292_clasts
lasts57731262__lasts
myoblasts1643902myoblasts
oasts56529182o__asts
oblate82214742obla_te
oblates91913242oblates
oboists937902oboists
obtests9136232obtests
outlasts8108712outlasts
abases85720773ab_ases
ablate82219213abla_te
ablates92416903ablates
ablaut8313263ablaut_
ableists1036543ableists
ablest84721833ablest_
abwatts1233403abwatts
alants67722023_alants
anlases72514903anlases
atlases72410643atlases
baases85218013_baases
bahts105617803_b_ahts
baits76630583_b_aits
balases93815433balases
ballasts1037933ballasts
balsas86417523_balsas
bases75644353_b_ases
basis75429863_b_asis
basks115621763_b_asks
bass66146783_b_as_s
bast66362413_b_ast_
baste74829983_b_aste
bastes85330383_b_astes
bats66962333_b_a_ts
batts76727563_b_atts
beast76338643_beast_
beats76042243_bea_ts
beauts86015283_beauts
bests75932613_b_ests
biases84618433_biases
biblists1236873biblists
blabs95619633_bla_bs
blacks144914953_blacks
blades95221253_blades
blaffs14426623_blaffs
blahs105616513_bla_hs
blains84516373_blains
blames105121863_blames
blams95023853_bla_ms
blanks124112893_blanks
blares85021633_blares
blase75524233_blas_e
blasted104213473_blasted
blaster94017303_blaster
blasters104116143_blasters
blastie92411393_blastie
blasties102113633_blasties
blat66550953_bla_t_
blate75933783_bla_te
blaws105620463_bla_ws
blazes174817353_blazes
bleats85518613_bleats
bless75917813_bles_s
blest76431723_blest_
blets75324943_bl_ets
bliss75616913_blis_s
bloats85215763_bloats
blots75626173_bl_ots
bluets87215493_bluets
blunts84512893_blunts
blurts84412643_blurts
boarts84716873_boarts
boast75935703_boast_
boats75635153_boa_ts
bobcats1335993bobca_ts
bogarts1047743bogarts
bolas74733763bola__s
bolts76232113bol__ts
boluses94113833boluses
bombasts1444953bombasts
boosts86115013_boosts
bracts105617773_bracts
brants85723053_brants
brass75428023_bras_s
brats75336013_bra_ts
breasts939703breasts
bursts85116243_bursts
busts75227693_b_usts
casts77237793__casts
clasps104512093_clasps
class75525483_clas_s
clast76030583_clast_
coasts85719143_coasts
cobalts1139203cob_alts
coolants1039943coolants
dalasis8810533dalasis
delists84414173delists
demasts1089223demasts
dicasts1078703dicasts
doblas93812293dobla__s
dynasts1155103dynasts
easts57530323__easts
eclats8313033ecla_ts
ectoblasts1454033ectoblasts
endoblasts1354323endoblasts
enlists749393enlists
entoblasts1254753entoblasts
epiblasts1343353epiblasts
fasts86429683__fasts
feasts95116093_feasts
flasks13488673_flasks
flats86429743_fla_ts
gasts66628633__gasts
gelants82611443gelants
glass65518133_glas_s
glosts74513813_glosts
goblets103210183gobl_ets
heliasts1136103heliasts
holists104413963holists
hypoblasts2054693hypoblasts
idioblasts1352893idioblasts
jobless16237563jobles_s
kolbasis1443503kolbasis
lases54944763__lases
lass47444543__las_s
last46260323__last_
lats45962703__la_ts
leasts64616413_leasts
lists56628693__lists
lusts55022803__lusts
masts77035763__masts
mesoblasts1453983mesoblasts
molests93311563molests
myoblast1545243myoblast_
noblest93613563noblest_
nonpasts1046553nonpasts
oases55330983o__ases
oasis56422553o__asis
oast47156323o__ast_
oats46554213o__a_ts
obas65730933ob_a__s
obeahs1135863obea_hs
obelises1039103obelises
obelisks1443443obelisks
obelisms1236393obelisms
obias76116863obia__s
obiisms1135673obiisms
obits74617553ob__its
objects18123693objects
objets15125323ob_jets
obliges1037143obliges
oblongs1033533oblongs
oboist8312683oboist_
obsess845943obses_s
obtains939163obtains
obtest81213013obtest_
obverts1235403obverts
octants9128733octants
oculists1037133oculists
odists749853o_dists
offcasts1643013offcasts
ollas54218283olla__s
onlays9398713onla_ys
oocysts1243923oocysts
oralists8611803oralists
orbless937493orbles_s
orgasms1054293orgasms
orgiasts943803orgiasts
ousts55225703o__usts
outacts9310213outacts
outasks1138173outasks
outboasts1144763outboasts
outcasts10108683outcasts
outfasts11117233outfasts
outlast71015443outlast_
owlets93110393owl_ets
oxcarts1634313oxcarts
pasts75936503__pasts
peltasts1035703peltasts
plaits83816473_plaits
plants84921803_plants
plasms103711333_plasms
plats75531373_pla_ts
poblanos1244993poblanos
pollists10910823pollists
recasts93413533recasts
relists73817053relists
repasts93611933repasts
roasts64915413_roasts
slants64819083_slants
slats55436903_sla_ts
splats84817303spla_ts
toasts65914993_toasts
topmasts1244973topmasts
umlauts943193umlauts
upcasts11185643upcasts
vasts86423773__vasts
volosts1036563volosts
wasts87433673__wasts
webcasts1543313webcasts
xenoblasts1953563xenoblasts
yeasts96413053_yeasts

Search took 7 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.390458182.1
2DLD Change Limit1340272136.50020619.5
3Display Results2132130.0633381.0
 (SQL Overall)1786912136.95325699.8
 
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.