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

164 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
ballsier103652(None) 
balkier134111982ba_lkier
ballaster1145972ballaster
baller83825202ball__er
ballies93725742ball_ies
balloter1078892balloter
ballsiest1145412ballsiest
balmier113811512ba_lmier
baluster1037052baluster
baulkier1433532baulkier
bullier94116432bull_ier
dallier84215372dall_ier
pallier94417162pall_ier
rallier73816272rall_ier
sallier73320422sall_ier
tallier72817212tall_ier
allayer10148213_allayer
alleger8319633_alleger
allied74217153_all_ied
allies63827673_all_ies
allover1038583_allover
allseed835953_allseed
allurer7348433_allurer
antsier7410773_antsier
artsier768943_artsier
babier103515573ba__bier
baggier113611643ba_ggier
bailer85425253bail__er
bailie83818363bail_ie_
bailies94120203bail_ies
bailsmen1244623bailsmen
balancer1246603balancer
balases93815433balas_es
balder95318863ba_l_der
baldies105317703ba_ldies
balefire1344663balefire
baler75635273ba_l__er
balisaur1043263balisaur
balker124519163ba_l_ker
ballade104012563ballade_
balladeer1243023balladeer
ballades114211643ballades
ballasted1245453ballasted
ballasters1245093ballasters
balled94926893ball__ed
ballers94421013ball__ers
ballet84733973ball__et
balling104424763ball_ing
ballista1045803ballista
ballonet10314503ballonet
balloted1189043balloted
balloters1157673balloters
balls76236413balls___
ballsy11508873balls__y
ballute938543ballute_
ballutes1037523ballutes
balusters1136643balusters
banisher13169183banisher
banister10199973banister
barkier133814483ba_rkier
barmier114313043ba_rmier
barnier93213673ba_rnier
barrier94017733ba_rrier
baser74828923ba__s_er
basher115123813ba__sher
basifier1337313basifier
baster85333593ba__ster
battier93515713ba_ttier
bawdier13378203ba_wdier
bawler114315053bawl__er
belier84423563b_el_ier
bellied104314073bell_ied
bellies94023723bell_ies
bellower13159063bellower
bilgier10358533b_ilgier
biller84923483bill__er
billeter1037563billeter
billie85019173bill_ie_
billies93923503bill_ies
billowier1444293billowier
bitsier9379073b_itsier
blaster94017303b_laster
blastier10249493blastier
blesser9329293b_lesser
blister94415313b_lister
blousier1055663blousier
blowier1248943b_lowier
blowsier1335063blowsier
bluesier1034943bluesier
blusher124113113b_lusher
bluster94215313b_luster
bolster93713423b_olster
bossier93712423b_ossier
brasier94516753b_rasier
brassier103310533brassier
brawlier13267043brawl_ier
bulgier103911213b_ulgier
bulkier134111513b_ulkier
bullbrier1343683bullbrier
bullied104514813bull_ied
bullies94121893bull_ies
burlier93514413burl_ier
busier85219723b__usier
caller85125483call__er
calliper1247513calliper
callower13159073callower
classier10359083classier
collier93618153coll_ier
dallied93713613dall_ied
dalliers93610613dall_iers
dallies84023193dall_ies
earlier72612743earl_ier
easier64218463ea__sier
faller94621233fall__er
falser93912413fa_ls_er
falsie93513853fa_lsie_
falsies103515013fa_lsies
faultier1135283faultier
folksier1533533folksier
gallied94115003gall_ied
gallies84122713gall_ies
galloper11137193galloper
gassier83812573ga_ssier
glassier9289083glassier
hallower14139813hallower
haulier1059943haul_ier
haulmier1333143haulmier
hillier103413963hill_ier
jollier142911003joll_ier
malmier113611953ma_lmier
maltier93015483ma_ltier
maltster1035303maltster
manlier92414023manl_ier
marlier92614773marl_ier
massier93615223ma_ssier
millier93716703mill_ier
palier85023563pa_l_ier
palmier113312173pa_lmier
palsied102911303pa_lsied
palsies94420273pa_lsies
paltrier1037533paltrier
pollster1037103pollster
rallied83514083rall_ied
ralliers84010833rall_iers
rallies73823343rall_ies
sallied83316953sall_ied
salliers83613343sall_iers
sallies73227813sall_ies
sallower11139503sallower
saltier74318633sa_ltier
sassier73413233sa_ssier
sillier74017593sill_ier
talkier114011843ta_lkier
taller63721963tall__er
tallied83314753tall_ied
talliers83711373tall_iers
tallies73624603tall_ies
tallises82713263tallises
tarsier74119253ta_rsier
vaultier1144293vaultier
wallie93216803wall_ie_
wallies103320743wall_ies
walloper13147113walloper
wallower14158933wallower

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.423422437.4
2DLD Change Limit1461621647.06020702.8
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.54623680.2
 
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.