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

216 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
baluster103705(None) 
balusters1136631balusters
bluster94215311b_luster
ballaster1145972ballaster
balloter1078892balloter
ballsier1036522ballsier
banister10199972banister
baster85333592ba__ster
blaster94017302b_laster
blister94415312b_lister
blunter94512032b_lunter
blurter9419832b_lurter
blusher124113112b_lusher
blusters104413882b_lusters
blustery13368002b_lustery
bolster93713422bol_ster
buster84726492b__uster
cluster94013322_cluster
deluster936902deluster
fluster103913062_fluster
luster64023672__luster
maltster1035302maltster
saluter73512452salu_ter
abluted10188363ablu_ted
abrupter1243793abrupter
abuser85413683_abus_er
abutter957513_abutter
acuter84412863_acu_ter
adjuster1644343adjuster
aflutter1163813aflutter
alastor739653_alastor
alerter72111513_alerter
alter54828503_al__ter
amuser84712623_amus_er
aster55434893_a__ster
auguster943943auguster
austere7312993_a_ustere
baiter84422553ba__iter
balancer1246603balancer
balases93815433balas_es
balder95318863bal__der
baler75635273bal___er
balisaur1043263balisaur
balker124519163bal__ker
balkier134111983bal_kier
ballasted1245453ballasted
ballasters1245093ballasters
baller83825203bal__ler
balloted1189043balloted
balloters1157673balloters
ballute938543ballute_
ballutes1037523ballutes
balmier113811513bal_mier
banisher13169183banisher
banisters11189473banisters
bannister1155373bannister
banqueter2043993banqueter
banter84825333ba__nter
barrater10310143barrater
barrister1145733barrister
barter85525373ba__rter
baser74828923ba__s_er
basher115123813ba__sher
baste74829983ba__ste_
basted95227233ba__sted
basters94930303ba__sters
bastes85330383ba__stes
batiste939743batiste_
batistes1039713batistes
batter84928873ba__tter
baulkier1433533baulkier
belter84720963bel__ter
billeter1037563billeter
bilsted1038033bil_sted
bimester1236163bimester
bister84922763b__ister
blasted104213473b_lasted
blasters104116143b_lasters
blastier10249493b_lastier
blatter94415653b_latter
bleater94515303b_leater
blesser9329293b_lesser
blisters104015083b_listers
blistery13418713b_listery
bloater94013423b_loater
blotter94612853b_lotter
blousier1055663blousier
blubber10399293b_lubber
blucher143310223b_lucher
bludger11419563b_ludger
bluer74918493b_lu__er
bluesier1034943b_luesier
bluestem1243223b_luestem
bluffer15396883b_luffer
blunder103813143b_lunder
blunger104112013b_lunger
blunted104210663b_lunted
blurted10399783b_lurted
blurters10348363b_lurters
blushed134411753b_lushed
blushers133911293b_lushers
blushes124314823b_lushes
blustered12157263b_lustered
blusterer11176293b_lusterer
boaster94616433b_oaster
bolsters103712443bol_sters
bolter83920753bol__ter
boluses94113833bolus_es
booster94314553b_ooster
bruiter93710633b_ruiter
brusher123813003b_rusher
brusker13437853b_rusker
bunter85020383b__unter
burster9310293b_urster
busher114922203b__usher
busier85219723b__usier
busker125517833b__usker
busted95123153b__usted
busters94724123b__usters
bustier93916153b__ustier
bustler94012563b__ustler
butter84724233b__utter
cadaster1136893cadaster
calypter1544063calypter
canister101710853canister
caster85232573ca__ster
causer84117783ca_us_er
clusters102912393_clusters
clustery13317103_clustery
clutter94211653_clutter
clyster12317453_clyster
dabster1036703da_bster
daunter83811753da_unter
delusters1035973delusters
diluter8319653dilu_ter
duster74919723__duster
easter65027983ea__ster
enlister847803enlister
falser93912413fal_s_er
falter94519053fal__ter
faster94625773fa__ster
filister1137403filister
flaunter1135013flaunter
flusher133012273_flusher
flusters113811493_flusters
fluter95316863_flu_ter
flutter104012093_flutter
gagster9317633ga_gster
gamester1137323gamester
gangster10215773gangster
ganister9178993ganister
gaster75027353ga__ster
gaunter82910713ga_unter
glister84013343_glister
halter94420883hal__ter
hamster12810423ha_mster
haunter103111153ha_unter
holster103512213hol_ster
jouster143311043_jouster
juster134617013__juster
klister113410643_klister
lackluster1652023lackluster
lamister1037653lamister
lamster9109913la_mster
laster64830633__laster
lister64527253__lister
lusher93818763__lusher
lusted74319443__lusted
lusters73921433__lusters
lustier73813503__lustier
lustre64011683__lustre
magister1136283magister
maltsters1135193maltsters
master84831343ma__ster
molester1099373molester
muster84724523__muster
oldster896573_oldster
ouster64223733__ouster
palmister1345053palmister
palter84423263pal__ter
paster85734373pa__ster
pauser84415963pa_us_er
pilaster1038163pilaster
plaister1068013plaister
plaster93318693_plaster
plusher124010383_plusher
pollster1037103pollster
raster64731443ra__ster
robuster1035663robuster
rouster73517083_rouster
salter64325083sal__ter
salute64418023salu_te_
saluted84511703salu_ted
saluters8319853salu_ters
salutes73716253salu_tes
saunter72913453sa_unter
splutter10357443splutter
subcluster1443133subcluster
taluses7311213talus_es
tapster9299273ta_pster
taster64930573ta__ster
taunter73111453ta_unter
tauter64318023ta_u_ter
thruster1135793thruster
truster73114313_truster
ulster63712103_ul_ster
valuate102512733valuate_
valuated12239203valuated
valuates112811193valuates
valuator1196723valuator
valuer93911443valu__er
vaster94521023va__ster
vaulter10257713va_ulter
vaunter10309603va_unter
waister103812383wa_ister
waster95228943wa__ster

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.1561145455.1
2DLD Change Limit1461622166.98320931.1
3Display Results2162160.0932322.6
 (SQL Overall)1786912167.23224708.4
 
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.